Is it possible to delete blank space in a Text Box.
For example, I am fetching data using Dlookup Function
LC = Nz(DLookup("OFFICE", "OFFICE_CODE", "OF_CODE = 1 AND CHK=TRUE"))
MC = Nz(DLookup("OFFICE", "OFFICE_CODE", "OF_CODE = 2 AND CHK=TRUE"))
NC = Nz(DLookup("OFFICE", "OFFICE_CODE"...