(R) text field become registered trademark (1 Viewer)

[lcline]

Thanks in advance,

I have a combo box that displays the concantanation of two fields. Both are text.

The first column holds a alpanumeric value that does not give much description. The second holds a the description of the second.



The problem I am having is the second field ends in (R). When I concantanate the the two, it is seen as ending in a registered trademark and I get the error message that it does not match anything in the list. I am not using that column as the bound column.

example
Desc: [SERNUM] & " - " & [Description]

SERNUM = BR549
Descrition = Junior Samples (R)

Desc = BR549 - Junior Samples (trademark)

Error Not in list

Is there a way around this?

Thanks,
Lee

 

[daveUK]

In Access try Tools - AutoCorrect Options and you can then delete (R) from the list.