X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
   Reply to this topicStart new topic
> Using Ccur Within A Text Field Value, Office 2007    
 
   
Scot
post Feb 27 2012, 09:28 AM
Post#1


UtterAccess Guru
Posts: 806
Joined: 24-November 08
From: Silver Spring Maryland, USA


If have the following vba command for a textbox. Me.Txt_CallbackInstructions.Value = "the amount of $" & Me.Txt_SumUnpaid & ". This is a reminder"
e.Txt_SumUnpaid is formatted as currency with a control source that includes a DSum to gather the information. Using the following syntax in my .value code yields these results
" & Me.Txt_SumUnpaid & " Results In 2 or 2.5
" & CCur(Me.Txt_SumUnpaid) & " Results In 2 or 2.5
" CCur(& Me.Txt_SumUnpaid &) " Results in errors
What's the proper syntax?
Go to the top of the page
 
Larry Larsen
post Feb 27 2012, 09:51 AM
Post#2


UA Editor + Utterly Certified
Posts: 23,522
Joined: 26-August 02
From: Melton Mowbray,Leicestershire (U.K)


Hi Scot
Sorry are we simply trying to format the results..!!!
thumbup.gif" style="vertical-align:middle" emoid=":thumbup:" border="0" alt="thumbup.gif" />
Go to the top of the page
 
Scot
post Feb 27 2012, 10:24 AM
Post#3


UtterAccess Guru
Posts: 806
Joined: 24-November 08
From: Silver Spring Maryland, USA


Opps, how did I miss saying that. Yes, I want to format the inserted field comment.
Go to the top of the page
 
Scot
post Feb 27 2012, 11:45 AM
Post#4


UtterAccess Guru
Posts: 806
Joined: 24-November 08
From: Silver Spring Maryland, USA


Ah, that works. I was so caught on CCur that I didn't think of Format. Always another way to skin the cat.
Go to the top of the page
 


RSSSearch   Top   Lo-Fi    26th January 2015 - 11:24 AM