I just tried it again here and got the same thing. I had done a quick test
with an unbound textbox and it had worked with that.
So basically, the answer is No, but there is a work around.
1) Place another textbox exactly over the current textbox. Delete the label
for this new textbox.
2) For this new textbox, set Enabled to No, Locked to Yes, Control Source to
="Required", ForeColor to Red (use the color picker).
3) In the AfterUpdate event of the current textbox and in the Current event
of the form, hide/unhide this new textbox as needed.
4) When the new textbox is visible, since it can't receive the focus, when
you tab or click into it, it'll actually go to the background and the
current textbox will show through. This will let you make your entry.
This will "look" like what you're asking for.
--
Wayne Morgan
MS Access MVP
"Ian" <ia********@ntlworld.com> wrote in message
news:Dh**************@newsfe1-gui.ntli.net...
I tried setting the Input Mask to: 99/99/0000;0;_ and leaving the Format
as:
@;"Required"[Red]. My date set to 02/10/04 now shows 38262.