Print Space instead of decimal on pre printed form

[leej1]

Hi
I have a pre printed form with decimals printed on the form. I want to print a space where decimal is in a fixed 2 decimal control.
ex 12345.56
12345 56
Sounds simple, but have trouble solving.
Thanks
leej1

 

[misscrf]

something like...

=IIF([field]=*&"."&*,*&" "&*,[field]

you might need #'s but not sure.

misscrf

It is never too late to become what you could have been ~ George Eliot

 

[leej1]

I get a syntax error when entering your susgestion.
Thank you

 

[misscrf]

I'm sorry, I meant to say that it might work as something like that. You will have to play with the syntax. The idea is using the If and only IF statment in the field.

It says that the field = IIF ([fieldinquestion] = something, "true statement with text in quotes", "false statement might be a"&[field]&"and/or with text in quotes"


use the & to connect a field to text like "The answer is: "&[field]


You will have to play around with needing #*#&"."etc or seeing if there is something in Access help to define has decimal....


misscrf

It is never too late to become what you could have been ~ George Eliot