Input Mask

[Loi]

Hi,
Please,show me how can I create custom input mask for
DATE/TIME field.

I would like to have a input mask like #01 12/11/04.
----------
I tried to custom the new input mask by using Edit List
button on Input Mask wizard. However, when I type the date
(12/11/04)and ( #01), I received the message like "you may
have entered text in a mumeric field or a number that is
larger than the FieldSize setting permits."

Please show me how to fix the problem.
__________________________

Is there another way to create input mask?

Thank you
Chi Huynh

 

[fredg]

Hi,
Please,show me how can I create custom input mask for
DATE/TIME field.

I would like to have a input mask like #01 12/11/04.
----------
I tried to custom the new input mask by using Edit List
button on Input Mask wizard. However, when I type the date
(12/11/04)and ( #01), I received the message like "you may
have entered text in a mumeric field or a number that is
larger than the FieldSize setting permits."

Please show me how to fix the problem.
__________________________

Is there another way to create input mask?

Thank you
Chi Huynh

You can't!!!!
A date field is a date field and the data entered must be a valid
date.
There is no such date as #01 12/11/04

I would suggest you use 2 fields, one to enter the #01 value (assuming
it changes) and the other to enter the date value.
You can then concatenate them when you need the values together, i.e.
= [FieldA] & " " & [DateField], or simply place the 2 controls
alongside one another.

Alternatively use a Text datatype field, but then the #01 12/11/04
value will be text, not date datatype.