Access Converts (C) to Copyright Symbol - How to Stop 1

[dftjsn]

I have a combo box with a table record source that contains a record such as:

Maple (C)

In the combo box drop down, it looks correct, but when you select Maple (C) or type it in, Access converts the (C) part to the copyright symbol and generates a not in list error message.

How do I prevent Access from converting the (C) to the copyright symbol in the combo box?

Thanks!

dftjsn

 

[thornmastr]

Turn off auto correct. I think it is some where under options. Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com

 

[bhargi]

Are you using the captial or small C? I think if you use capital (C) you won't see copy right symbol at run time.

If you use small (c) you see copyright symbol.Another way is to add some code to convert into string or use double quotes around the (C)

For example
combo_update event()
'select a value from the combo (this attaches the (C) for every item you selected in the combo) so modify your code accordingly where you need only for maple or others If you need only for maple use IF condition.

Dim str As String
str = Forms!form2!Combo2
str= str & "(C)"

use this str variable wherever you want.

 

[dftjsn]

Thanks Robert ...

You were right. Under Tools-AutoCorrect, Access 2000 is set to convert (C) to the copyright symbol. (R) and (TM) also get converted automatically. This can be shut off at this menu or on the property sheet of individual controls.

dftjsn