Input Mask / Format

[Guest]

I have the following:

Table: tblCompanyInformation
Field within the table: CompanyName (allowed 100 characters)
Field Type: Combo Box
Combo Box Source: SELECT [CompanyName] FROM [tblCompanyNameList];
Input Mask for both the combo box field and the text field (in the source
table) is: 000" - "ACCCCCCCCCCCCCCCC... (for a total of 100 characters -
maybe there is a better way?)

When data is inserted into the text field (CompanyName) for the source table
(tblCompanyNameList) it works correctly. For example, the user enters 010 and
the "-" is automatically inserted and the user continues entering data one
space to the right of the dash.

I want the data to look like: 010 - Time Warner

What I see in the combo box field (CompanyName) of the table
(tblCompanyInformation) is: 010TimeWarner

How can I resolve this mystery. I have tried various different input masks
but no luck.

Any help would be appreciated. Thank you in advance for responses.

Rick

 

[John Nurick]

I'd tackle this by putting the number in one field - text, 3 characters,
with a Format of "000" - and the name in a second. In the combobox, I'd
use two columns, either
-one for the number and one for the name
or
-one for the number (hidden by setting its width to 0) and one with the
name and number concatenated with a " - " between them.

I have the following:

Table: tblCompanyInformation
Field within the table: CompanyName (allowed 100 characters)
Field Type: Combo Box
Combo Box Source: SELECT [CompanyName] FROM [tblCompanyNameList];
Input Mask for both the combo box field and the text field (in the source
table) is: 000" - "ACCCCCCCCCCCCCCCC... (for a total of 100 characters -
maybe there is a better way?)

When data is inserted into the text field (CompanyName) for the source table
(tblCompanyNameList) it works correctly. For example, the user enters 010 and
the "-" is automatically inserted and the user continues entering data one
space to the right of the dash.

I want the data to look like: 010 - Time Warner

What I see in the combo box field (CompanyName) of the table
(tblCompanyInformation) is: 010TimeWarner

How can I resolve this mystery. I have tried various different input masks
but no luck.

Any help would be appreciated. Thank you in advance for responses.

Rick