Input Mask / Format

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...
 
Back
Top