Inputbox: input mask? (1 Viewer)

[G37Sam]

Hello,

Is there a way i could mask (password mask) an input box and make it display asteriks when users types in it? [just like in a textbox]

Cheers,
Samer

 

[boblarson]

Nope, not easily. There is an API out there somewhere that will do it, but it is just easier to create your own form and call it when you need it. If you use the DoCmd.OpenForm command you can set the mode to DIALOG which will then pause your code and wait for input into your form and then you close the form.

 

[G37Sam]

hey bob thx for your reply
man this API business i will never get.. speaking of which.. i found an API code to display the common dialog box (open.. save etc) because for some reason i had a problem with ActiveX
anyhows, when using "open".. the dialog pops up filtering for jpg files each and everytime.. is there a way i can make it filter for "xls" files or just show all files?

regards,
Samer

 

[boblarson]

Yeah, but I haven't gotten that one down yet. If you look here, it has an xls filter as an example:
http://www.mvps.org/access/api/api0001.htm