line returns within text field (Access 97)

[ckennerdale]

How is it possible to set a property with a text or memo field so that the user can input data on separate lines.

So having text like this

1) Test
2) Test
3) Test

instead of like this

1) Test 2) Test 3) Test

Cheers, and sorry for such a basic question

 

[dmh4ab]

May not be what you're looking for, but if the user presses ctrl + enter they can insert the hard return.

dmh4ab

 

[MakeItSo]

Yepp, correct.

But as an Info: This inserts a soft return (Line feed) between the text lines. This can lead to problems when exchanging data with other apps. Some applications automatically replace the LineFeed with a CarriageReturn+LineFeed (Hard return).

When trying to re-import such data into Access, records would shift...

Andreas Galambos
EDP / Technical Support Specialist
(andreas.galambos@bowneglobal.de)
HP:

http://www.andygalambos.de

 

[ckennerdale]

cheers

Caspar Kennerdale

 

[JoeCruse]

Caspar,

if I understand your queston correctly (you're talking about a field in a form?), then in the Properties-Other Tab section for the field, in Form Design View, set the "Enter Key Behavior" to "New Line in Field".

I have several forms in my applications with Memo fields that are set up like this.

Joe

 

[JoeCruse]

Whoops! I don't remember if you'll have this in '97 version. Sorry!

Joe