Treat a 1 byte space as a valid character.

[MandM22]

I have a form linked to a SQL DB. There is a column on the table that is defined as 1 byte character... Not Null... default value = ' '. If I edit this column via a linked table on a form and try to enter a space it does not see the space as a valid character and tries to update the row with null.. which is not allowed. Is there a way to force the space character to be recognized in Access as a valid character?



Thanks for any help, advice, or tips.

[June7]

Not that I know of. Access drops spaces at the end of data and so a solo space is dropped. Why would you want a space in field?

[MandM22]

Not that I know of. Access drops spaces at the end of data and so a solo space is dropped. Why would you want a space in field?

The field is an indicator ... Default of space in SQL. If turned on they enter a 'Y'. Turned off is assumed to be a space. Table is used by several applications. Some may have coding looking for the space specifically. In theory a 'N' should be the default value and mean the indicator is off. I may not be able to use the 'N'. Bad table design I'm stuck dealing with...

Thanks for the response... I figured there wasn't anything I could do...