Access input mask

T

tony

we are trying to put a duel mask on a field so that the
data in the field is either a date in the 00/00/0000
format or the word NO.

is this possible?
 
R

RobFMS

It is, but you will have to handle it via code.
Is there another field that indicates whether the date appears or the
wording appears?
If so, use the After_Update() event or Change() event of the control.

Syntax (example): Me.Text1.InputMask = "99/99/0000;0;_"

HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
N

new

ÎÒÒѾ­²âÊԳɹ¦


RobFMS said:
It is, but you will have to handle it via code.
Is there another field that indicates whether the date appears or the
wording appears?
If so, use the After_Update() event or Change() event of the control.

Syntax (example): Me.Text1.InputMask = "99/99/0000;0;_"

HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Click to expand...
 
Top