If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Input Mask
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 |
#2
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
spaces input mask | Paul | Setting Up & Running Reports | 0 | November 8th, 2004 08:01 PM |
How to use a default value within an input mask | Kathy | Database Design | 1 | September 3rd, 2004 06:35 PM |
DateTime field input mask | Jim Franklin | Using Forms | 3 | August 8th, 2004 05:19 PM |
input mask | lynn atkinson | Using Forms | 2 | July 29th, 2004 06:29 PM |
Input Mask not working ? | TonyB | Database Design | 4 | May 11th, 2004 11:26 PM |