Multiple line in a field???

[simon4amiee]

Hi guys again, Ive exported some data which has 3-4 address line within the same field which is very odd.

The row has all the usual data, but when I look at the data in datasheet view the adresss line 1 shows only but when I click into the field and press down, more address info comes up. Is there any way to have this on one row within the field rather than multiple.

A bit like in Excel when you Alt+Tab in a cell it drops down but is the same cell, well this exactly like that in Access 2003.

 

[namliam]

You mean alt+ENTER, not Tab, you can replace out the "New line" character to re-center the information on one line....