Carriage Return in Access field 1

[TracySHC]

I need to export an Access file into another software package. This other software does not accept blank or null fields very well. However, if a carriage return is entered in the Access field, the field can be exported from Access and imported into this other software without a problem. How can I porgram in Visual Basic to enter a carriage return in an empty field? Can a variable hold the unprintable character?
Thank you for your help and advice,
TracySHC

 

[earthandfire]

Use VbCr CarriageReturn) or VbCrLf (CarriageReturnLineFeed equivalent to Enter)

Hope this helps.