number zero in text field

[hireagenius]

Hi heros,
I have a text field that stores numbers like 06-1234. I created a combo box
to look up values on a form based on the number. However, I can't get it
formatted correctly. It is formatted @@-@@@@.
The results are 0-61234 in the combo box. Can you assist me?
Thank you
Charlie

--
Message posted via http://www.accessmonster.com

[salad]

Re: number zero in text field

hireagenius wrote:

Hi heros,
I have a text field that stores numbers like 06-1234. I created a combo box
to look up values on a form based on the number. However, I can't get it
formatted correctly. It is formatted @@-@@@@.
The results are 0-61234 in the combo box. Can you assist me?
Thank you
Charlie
>

Expr1: Format("61234", "00-0000") 06-1234
Expr2: Format("061234" ,"00-0000") 06-1234
Expr3: Format(61234,"0 0-0000") 06-1234