BE : Sql Server ---- FE : Access
I have a remark field in a table that needs to be filled with some special characters. I type the character in the textbox of a single form, move to the next record and then move back to the same record. The special character is just fine. but as soon as I requery the form, the special character changes to something else.
Example:
I need to enter 107 cubic meter. I type 107 then m and then ALT+0179 --> the textbox in the form shows it as 107m³
Requering the form changes it to 107m3
ø changes to o
I've tested it on varchar and text data types.
Both shows the same result.
How can I keep the inserted special characters?
Any kind of advice is much appreciated.
I have a remark field in a table that needs to be filled with some special characters. I type the character in the textbox of a single form, move to the next record and then move back to the same record. The special character is just fine. but as soon as I requery the form, the special character changes to something else.
Example:
I need to enter 107 cubic meter. I type 107 then m and then ALT+0179 --> the textbox in the form shows it as 107m³
Requering the form changes it to 107m3
ø changes to o
I've tested it on varchar and text data types.
Both shows the same result.
How can I keep the inserted special characters?
Any kind of advice is much appreciated.
Last edited: