Need to store spaces as value of text field

[Nancy26]

I have a form in which the user enters up to 4 lines of text that will later be used in a report.

They need to have the ability to enter either text OR all spaces OR null as the possible values for each line.

However when I enter spaces and no other text, Access does not acknowledge the
spaces as characters and considers the value of the field as null.

Is there some setting or something I can do that will allow spaces that a user types to be stored in in a field?

Thanks,

Nancy

 

[David R]

Would setting the "Required" property of the field to No do what you're asking? Or do you need to ensure that they at least typed something in the field? You could probably do it with a Validation Rule.

HTH
David R.