All CAPS

[Guest]

I copied an earlier string for reference to my question. I tried what
Douglas says below but I am still getting the error Lonnie was getting.
Any new suggestions.

 

['69 Camaro]

Hi, Joe.

The error message you get is in bold text on the first line, then some text
will follow in the paragraph below explaining the error message. Please
type the entire bold text line verbatim in your next post, with any spaces,
carriage returns, single quotes, periods, et cetera, that you see in the
error message, so that we can help you interpret it. (The paragraph that
appears below the error message is just an FYI, so we don't need to see it.
Just the actual error message is needed.)

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[Guest]

Microsoft Access can't find the macro 'KeyAscii = Asc(Ucase(Chr(KeyAscii))).'

Thanks for the help!

 

[Dirk Goldgar]

Microsoft Access can't find the macro 'KeyAscii =
Asc(Ucase(Chr(KeyAscii))).'

It sounds like you juat typed, or pasted, that single line into the "On
Key Press" property of the control. That's not what Doug intended. The
On Key Press property should be set to "[Event Procedure]" (without the
quotes), and then you need to click the "build button" (caption "...")
at the end of the property line to build an event procedure for the
control's KeyPress event. You should paste that line of code into the
event procedure, between the "Sub" and "End Sub" lines.

 

[Guest]

Thank you, I did not know where to put it.
Thanks Again, it works great!

Microsoft Access can't find the macro 'KeyAscii =
Asc(Ucase(Chr(KeyAscii))).'

It sounds like you juat typed, or pasted, that single line into the "On
Key Press" property of the control. That's not what Doug intended. The
On Key Press property should be set to "[Event Procedure]" (without the
quotes), and then you need to click the "build button" (caption "...")
at the end of the property line to build an event procedure for the
control's KeyPress event. You should paste that line of code into the
event procedure, between the "Sub" and "End Sub" lines.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)