Essay

[COB]

Does anybody know if it is possible to write multiple lines into a text box, ie when I'm writing and I press enter, the cursor moves onto the next line. Or should I be using another object.
Thanks in advanve.
COB

 

[KevinM]

Yes, just change the 'Enter key Behaviour' to 'New Line in Field' in the field's properties ('Other' tab).

You will be limited to 255 character so a MEMO field might be better which can hold around 64,000 (?)

 

[COB]

Thanks

That works perfectly!!
Thanks a million
COB

 

[essyweb]

That work perfect

 

[essyweb]

your work perfect.

 

[missinglinq]

Just be aware that 'essay' type data, notes, etc, is all that you should be using a Memo field for! It shouldn't be used for any data that you will ever have to manipulate in any way, shape or form, such as searching, sorting on parsing out into its component parts!

I frequently see people wanting to enter entire addresses into one field, and then trying to separate out the various components and it's a nightmare! Each part of an address needs to go in its own, distinct field. Same thing if you're writing notes that will have to be updated at intervals and then retrieved for a specific date; need to have a separate record with ID info and date and Memo field for each note.

If you follow these rules Memo fields are great, otherwise they can become very problematical.

Linq ;0)>

 

[webessay]

Perfect work.I appreciate you.

 

[jimolejniczak]

As with the Single line text field, the Section field accepts all kinds of texts. Moreover, this area includes several lines and accepts more text than you'll ever need. Best used for essay type questions.

 

[speakers_86]

The other answer besides the one in post #2 would be to hold ctl and press enter.

 

[rodmc]

The other answer besides the one in post #2 would be to hold ctl and press enter.

you learn something new every day!!!!!!!!!!

Was aware that worked in Excel cells but didnt know it applied to txt boxes in access (never had the reason to do it right enough)

Still might come in handy some day

 

[missinglinq]

As with the Single line text field, the Section field accepts all kinds of texts. Moreover, this area includes several lines and accepts more text than you'll ever need. Best used for essay type questions.

Some questions:

1. What is a 'Single line text' field? If you are talking about a regular Text Field? If so, it's not limited to 'single' lines, it's only limited to 255 characters.
2. What is a 'Section' field? Are you talking about a Memo Field?
3. If the assumptions in #1 and #2 are correct, why did you feel the need to resurrect a year old thread, that was answered successfully, only to post information that was already posted in the thread?

We always welcome new members here, but please don't respond to a post, especially a year-old one, only to given information that has already been given! You'll notice that speakers_86's comment actually added to the thread, giving information that was omitted in the discussion a year ago.

And please take the time to at least learn the basics of Access nomenclature, even if English is not your first language. Not doing so makes it very difficult to understand what you're trying to say and will be a detriment if you need our help.

Linq ;0)>