I am working in Access 2000. I need to remove the hard returns that import with the data and replace it with a space. This occurs in an Address field that has the basic address then a hard return and the apartment number. I am looking for the VBA code that will accomplish this when a command button is pushed.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.