UtterAccess Discussion Forums > Using Ccur Within A Text Field Value

Full Version: Using Ccur Within A Text Field Value

UtterAccess Discussion Forums > Microsoft® Access > Access Modules

Scot

Feb 27 2012, 09:28 AM

If have the following vba command for a textbox. Me.Txt_CallbackInstructions.Value = "the amount of $" & Me.Txt_SumUnpaid & ". This is a reminder"

Me.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?

Larry Larsen

Feb 27 2012, 09:51 AM

Hi Scot

Sorry are we simply trying to format the results..!!!

Scot

Feb 27 2012, 10:24 AM

Opps, how did I miss saying that. Yes, I want to format the inserted field comment.

Larry Larsen

Feb 27 2012, 10:59 AM

Hi
Try using some thing like:

CODE

"bla bla " & FormatCurrency([Me.Txt_SumUnpaid],2) & "bla bla"

Scot

Feb 27 2012, 11:45 AM

Ah, that works. I was so caught on CCur that I didn't think of Format.

Always another way to skin the cat.

Larry Larsen

Feb 27 2012, 11:46 AM

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.