Case Sensitive parameter query

[RhondaStockton]

Hi there
I have a switchboard item opening a form relating to a parameter query. I need to make the parameter case sensitive so that everytime someone opens the form, the parameter box requests a case sensitive number.

Could you please assist?
Thank you

 

[mdmilner]

I've never noticed SQL to be case sensitive.
There are worksheet functions EXACT(str1, str2) to compare two strings.

What is a "case sensitive number"?

I'm not certain as I've never tried, but you might have to look at the ascii value of the characters in a given string to determine case. Another possibility is, VBA has the UCASE function and you could compare the string to itself after applying the UCASE function to one side.

If strTest = UCASE(strTEST) Then
  ‘  What to do
End If

Just noticed the VBA DoCmd.FindRecord action when peeking at VBA help. It does have a case specific option.

Mike

 

[mdmilner]

Ack. Variables should have been the same including capitalization. Typo error.

If strTest = UCASE(strTest) Then 
  ‘  What to do 
End If 

[code]

 

[RhondaStockton]

Thank you very much for the awesome responses! I was also a bit concerned about the case sensitivity and thought that the password box might be a good idea. Yours is working perfectly!
Thanks again!
ray:

 

[mdmilner]

While I really do appreciate a thank-you when I think I've contributed, I think you meant to thank somebody else, possibly in another thread. I'm not sure how much I actually helped you here.

Good luck.

Mike