MsgBox function, password mask?

[Randix]

When entering a prompt in a msgbox function, is there anyway to use a password mask, eg so when the user types a response, "****" appear rather than the letters or numbers?

 

[R. Hicks]

Access doesn't not allow for formating of an InputBox. To do what you want, you will need to build a small custom form to emulate an InputBox. I do this all the time. I think the standard InputBox that is in Access is about the ugliest thing I've ever seen.

HTH
RDH