Access input mask

[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?

 

[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

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[new]

ÎÒÒѾ­²âÊԳɹ¦

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

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Joseph Meehan]

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?

Possible but difficult to do directly. How about a real date, or null
and then use a IF Null in a query or report to make the output report the
date or "NO" ?