functions

[bleep]

hiya was wondering if anyone could help me, im setting up a userpasswor
using code but access doesnt recognise this

function:inputbox()

does anyone have any ideas on how to fix it please? i dont know any V
so am just using examples...
Thank

 

[Jeff Boyce]

Fix what?

You haven't described what isn't working.

What happens when you use

 

[Graham R Seach]

Try this:

'An InoutBox that puts its return value into a MsgBox:
MsgBox InputBox("This is a prompt (Enter some text...)", _
"This is my InputBox Title", _
"This is a default value, which you can overwrite")

'...or the same InputBox that puts the return value into a variable:
Dim strMyResult As String
strMyResult = InputBox("This is a prompt (Enter some text...)", _
"This is my InputBox Title", _
"This is a default value, which you can
overwrite")

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html