The text I have in the the field to be converted is not only Yes, True or On -it's Y for True, N for False-
When changing the format of the data type -in Design View- to Y/N using ; "Y" ; "N", a problem occurs upon saving, it states that the FieldSize property has been changed to a shorter size, thus deleting the previous data.
How do I fix this?
PS : Display Control is set to Text Box, so that's not the problem.
PPS : No validation rule or text is entered as well.
When changing the format of the data type -in Design View- to Y/N using ; "Y" ; "N", a problem occurs upon saving, it states that the FieldSize property has been changed to a shorter size, thus deleting the previous data.
How do I fix this?
PS : Display Control is set to Text Box, so that's not the problem.
PPS : No validation rule or text is entered as well.