Special Format for text in combo box

  • Thread starter Thread starter Sammie
  • Start date Start date
S

Sammie

I have a lookup field on table1 to a field on table2. It is bound to the
primary key (auto-number) of table2, and the value I want to look up is a
10-character text field with an input mask of xxxx.xx.xx.xx

When I view the text field in the table2, it is formatted correctly.

When I view the field in the drop-down list of my combo box on my form, it
is formatted correctly as xxxx.xx.xx.xx

When I select the value I want on my form, it appears as xxxxxxxxxx (without
the dots).

How can I format the combo box text data with the dots when the value of the
combo box is a number, and why doesn’t it display the text column the same
way as it does in the table?
 
Sammie said:
I have a lookup field on table1 to a field on table2. It is bound to
the primary key (auto-number) of table2, and the value I want to look
up is a 10-character text field with an input mask of xxxx.xx.xx.xx

When I view the text field in the table2, it is formatted correctly.

When I view the field in the drop-down list of my combo box on my
form, it is formatted correctly as xxxx.xx.xx.xx

When I select the value I want on my form, it appears as xxxxxxxxxx
(without the dots).

How can I format the combo box text data with the dots when the value
of the combo box is a number, and why doesn't it display the text
column the same way as it does in the table?
Click to expand...

Format the box with @@@@.@@.@@.@@ in the table.
 
When I put that in the format property on the table, it automatically changes
it to @@@@\.@@\.@@\.@@
What's happening there?
Also, that makes the value of the text box completely disappear.
 
Back
Top