Format Currency Property

[ViRi]

Hi

I have a field on a Form that displays values in Sterling (The Default on the machine) ie with the pound sign before the numbers.

I need to change the sign before the numbers to Dollar at a click of a button. I'm not interested in actually converting the values from Sterling to Dollar but only to change the sign. So I attached the code below to a Button's On Click Event, but I get an error = Expected.

Format([ControlName] , "$#,##.00")

ViRi

 

[mhartman]

Hello

This is a function. You need to set it equal to something as below. Tested Okay

x = Format([Text0], "$#,##.00")

Regards
Mark

 

[ViRi]

Hi

I've tried this but it does not seem to work

Dim X
 X = Format([Text65], "$" & ([Text65].Value)) 'At this point nothing happens other than the assignment
 
 [Text65].Format = X 'With this line added it works intermitently? but it takes away the .00

ViRi