sorry about that....vbProper should be vbProperCase
****************************
Computers are possibly the most un-intelligent things ever invented, yet we let them control the world. Possibly a reflection of our own stupidity.
Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com
Both in the created field within the query and within the control source or format property fields of a report textbox Access is still adding on the brackets. Access really doesn't like it!
What version of Access are you using and have you looked up the StrConv() function to see what the correct constant (vbProperCase is a constant so you don't enclose it in ""'s)
is for your version.
It worked, you are a genious! Now for the super-challenge if you're up for it. I know this is a total longshot and has a 99% probability of being impossible, but here we go:
I've got a variety of names in this field, like the examples below:
Mr. Fred Rogers
Mrs. Smarty Pants, M.d.
See how the second letter is lower, although I'd like it to be upper? I can't change the data to be M._D. And I can't just add a rule to have the last letter upper... Any ideas?
I'm really pleased to have this tip, though, I appreciate your help, everyone.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.