I have create a combo box and text box pair. The combo box is used to select a value (business code) and the text box will display the associated title of the code.
i.e. 014 Retail Sale
a second pair is used for city business code
i.e. 28 Retail Sale
both pairs are setup identical. The problem is none of the values have leading zero ( in the table list) but the business code always displays as the 3 digit number with leading zero. The city business never displays the leading zero. Not sure if I am missing something. Would like the display to be consistent. Originally the city business codes were defined as 3 digit numbers with leading zero but when selected the text would never appear if there was a leading zero.
The combo box use a query to define selection list. The query returns 3 columns. The second column is the value and the 3 column is the text.
The text boxes are defined by "=[cbo_businesscode].[column](2)" and
"=[cbo_citybusinesscode].[column](2)" respectfully.
Currently both source table number have no leading zeros.
Any ideas?
Rod
Posted by: desertscroller@cox.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar