By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,153 Members | 2,581 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,153 IT Pros & Developers. It's quick & easy.

ChrW() Help...

Scott Price
Expert 100+
P: 1,384
Hello again...

This time I'm trying to get M$ Access 2003 VBA to accept the ChrW(215b) (this is the unicode number for the 1/8 character) standard... Each time I try to enter this, it beeps and gives me an error message " Compile Error Expected list separator or )"

Other unicode standard characters without letters in them are accepted fine... (for example the unicode number for the 1/3 character is 2153) Does anyone know how to get ChrW to recoginize ALL unicode characters, not just some of them?

Is this a missing reference issue, or a M$ standard operating procedure of making things only half work so you'll buy into their eternal upgrade treadmill?? (sorry if the sarcasm comes through, I'm a little frustrated at this point!)

Thanks for looking, and helping if poss...

Regards,
Scott
Aug 10 '07 #1
Share this Question
Share on Google+
3 Replies


Scott Price
Expert 100+
P: 1,384
Actually now I see that even though vba will 'accept' the chrw(2153) value, it will not display correctly in the access form view...

Hmm...

Regards,
Scott
Aug 10 '07 #2

FishVal
Expert 2.5K+
P: 2,653
Actually now I see that even though vba will 'accept' the chrw(2153) value, it will not display correctly in the access form view...

Hmm...

Regards,
Scott
You simply type hexadecimal numbers as decimal. ;)
Use "&H" predicate to tell VBA that number is hexadecimal. ChrW(&H215B)
Aug 10 '07 #3

Scott Price
Expert 100+
P: 1,384
You simply type hexadecimal numbers as decimal. ;)
Use "&H" predicate to tell VBA that number is hexadecimal. ChrW(&H215B)

FishVal, you've saved my day! I was almost ready to call it quits...

Thanks, that works like it should, and displays like it should also (miracle of miracles)...

Regards,
Scott
Aug 10 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.