Setting the format on a field in a form

[mduranko]

I have a number field on a form. I need to assign a prefix to the front of the number, example 1234 needs to appear as ZR1234. I know how to do this in the properties format field but it's not that simple. I need to build a code that sets the prefix to one thing if the number is less then 10,000 and to another prefix if the number is greater than 10,000. I have built a code using if, then else as well as the format function but it won't recognize the field as a number when I create the event procedure. I am writing the event on the form "OnOpen" property.

Any suggestions on what I'm doing wrong?

Thanks a bunch
Mike

 

[Ziggy]

Can't you accomplish this with an expression


=IIf([TestField]>10000,"ZR" & [ResultField],"AR" & [ResultField])



Ziggy