A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Input Mask



 
 
Thread Tools Display Modes
  #1  
Old November 18th, 2004, 06:17 PM
Loi
external usenet poster
 
Posts: n/a
Default 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  
Old November 18th, 2004, 06:44 PM
fredg
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 11:30 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.