By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,587 Members | 1,071 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,587 IT Pros & Developers. It's quick & easy.

number zero in text field

P: n/a
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
Jul 25 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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,"00-0000") 06-1234
Jul 25 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.