Special Format for text in combo box Sammie 11/16/2008 1:01:01 AM 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? -- Thanks. Sammie SBS 2003, OFFICE 2003, XP-PRO-SP3, IE7

Re: Special Format for text in combo box "Mike Painter" <mddotpainter[ at ]sbcglobal.net> 11/16/2008 3:10:05 AM Sammie wrote: [Quoted Text] > 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? Format the box with [ at ][ at ][ at ][ at ].[ at ][ at ].[ at ][ at ].[ at ][ at ] in the table.

Re: Special Format for text in combo box Sammie 11/21/2008 3:26:01 AM When I put that in the format property on the table, it automatically changes it to [ at ][ at ][ at ][ at ]\.[ at ][ at ]\.[ at ][ at ]\.[ at ][ at ] What's happening there? Also, that makes the value of the text box completely disappear. -- Thanks. Sammie SBS 2003, OFFICE 2003, XP-PRO-SP3, IE7 "Mike Painter" wrote: [Quoted Text] > Sammie wrote: > > 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? > > Format the box with [ at ][ at ][ at ][ at ].[ at ][ at ].[ at ][ at ].[ at ][ at ] in the table. > > >