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.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Nonprintable Characters (Hard Returns)
- Thread starter Gunny
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question