On Thu, 18 Nov 2004 09:17:09 -0800, Loi wrote:
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.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
|