Wierd editing problem; Form vs. Datasheet

[CactysJack]

I have a wierd problem with a database I kind of inherited and have to deal with.

Some items in the datasheet are composed of two lines of text where it seems like one is the normal. But anyway, some entries have two lines. I can edit either line by highlighting but cannot add a two liner on a new record or a record with only one line currently.

How did it get this way in the first place I wonder? On the other hand a Form with this data is readily edited just like normal text. Maybe that's how it was entered previously. It appears magically back in the datasheet view.

I would like to keep the two line (actually multiple line) function but am worried about the advisability given the datasheet's reluctance to go along.

It also means I can't use the Form Edit locking I would like to use for anti-corruption. Have to change (linked) data to Read-Only for normal non-editing use.

Any ideas?

TIA

John

 

[lorenahanna]

I'm assuming the field is a memo field? If so, it is easy to modify a memo field on a form and add additional lines by pressing the enter key.

When you are in datasheet view, you can press ctrl-enter to go to the next line. However, you will only see one line at a time. Also, once in the field, you can use the arrow keys to see the different lines.

 

[CactysJack]

Thank you lorenahanna,

The field is a text field. Probably it should have been a memo field. ctrl-enter in the datasheet didn't seem to quite do it. Arrow keys seemed to just go down to next record though after ctrl-enter it did seem to move up and down lines. But the ctrl-enter made a blank line between lines. Very confusing.

John