(c) value is changed to @ sign

[Marina]

I have a value store in the link SQL server as 12b(c). When user is
selecting this value through the combo on the form it turns out into 12b@ and
trigger fires since it does not recognize this value. It happens only on one
PC while on others it works fine. Is there a special setting in office or
access that changes the value of (c) to @.

 

[John Spencer]

Turn off the AutoCorrect property for the combobox. It is "correcting" the
value (c) to the copyright symbol.

 

[Marina]

Thank you very much Spencer. I deleted the line from the Aoutocorrect option
on the access Application level but I did not even know you can do it on the
combo box level.