Input Mask

[Guest]

Hi,

I have an Access 97 database. In one table, a field has a custom input
mask: 000000\-0000;0;_ If understand input masks correctly, this would
store the literal characters such as the "-" with the numbers in the field.
It functions properly in the form where the field is displayed. My issue is
that on a form which is a report writer, there is a list box that will
display the values of this field when the user clicks the appropriate option.
The values display without the "-" which makes it harder to read.

My question is: if the input mask is suppose to be storing the "-", why is
the "-" not showing up in the list box? The AfterUpdate event on the options
group is using simple SQL statements to query that tables for the list of
values for the various options users click.

I hope I have given enough information.

Thanks
LeAnn

 

[Guest]

I don't have a solid answer, but perhaps a good guess. The input mask for the
table can be different from the input mask for the control on the form. It
sounds like the form where the field is displayed uses a combo box, which has
an input mask property (and can thus be customized to match that of the
table), but the report generator is using a list box, and list boxes have no
input mask property.

So, my question is this: did you set the input mask of the input form only,
or is the input mask set for the field in the table also? This might have
some bearing, although I have not verified it.

 

[Guest]

Yes, the form input mask property was slighly different. I thought I had
already checked that. Thanks for making me take another look.