don't want my data (R) to be read as trademark

[abezuide]

Access understands my data (R) as the trademark registered. When trying to pick this from a combo box, it gives me an error that it doesn't exist in the list....sigh.... What can I do about this?

 

[ghudson]

I am not sure how you have set up the values and symbols in your combo box but this Row Source works for me...

®;Registered;©;Copyright

I used a two column combo box set to a Value List. The first column is bound to the symbol.

I just copied and pasted the symbol from the built in Character Set in the help files. Check out the Character Set (128 – 255) for those two symbols.

I tested the values in a message box and it returned the actual symbol from the value selected in the combo box.

HTH

 

[abezuide]

Thanks for the answer, no, my data read EPE(R) and was retrieved through a combo box. Everytime the client picks the EPE(R) it changes to the trademark and gives an error that the item is not on the list. There is however a setting in Access called autoreplace. One can pick the trademark value from there and just delete it for the current database. That proved to work well. Thanks for the help though, much appreciated!!!!