format an Input box

[yourdeployedson]

I have this input box

assword = InputBox("Enter new password:" & vbCrLf & "(Remember that passwords are case sensitive. Check that your CAPS LOCK key is OFF, and if your password contains numbers, that the NUM LOCK key is ON.)", "New Password")

I want to format it to show astrics like so

**********

How can I do this?

 

[TheAceMan1]

How are ya yourdeployedson . . .

Have a look at the [blue]line continuation character[/blue] . . .

See Ya! . . . . . .

 

[MajP]

Not sure if you can do that, but here is a work around.

Define a global variable "glblStrPassword". Build your own input form ("frmMyInputBox"). Have a a text box and use a password input mask. On the close event set the global variable equal to the value in your text box. Now build a function

public function myInputBox()as string
docmd.openform "myInputBox", , , , , acDialog
myInputBox = glblStrPassword
end function

This function pops open your InputBox and returns the password.

 

[TheAceMan1]

yourdeployedson . . .

Forget my post (misinterpretation). [blue]MajP[/blue] has you in tow . . .

See Ya! . . . . . .

 

[MajP]

See thread705-1192405. There is an interesting solution. It does not seem simpler, but it is interesting.