Memo Data Type


A

alex

Hello Experts,

I have a form in which users enter data.

On said form is a comment box that is tied to a table with a memo data
type in the applicable field. This arrangement seems to work until
the user presses enter or creates spaces in his/her text. It appears
that the table will only capture continuous text and noting else. Any
thoughts?

E.g., if the user types:

This case needs to be looked at. (this data is captured)
[space]
Please see tracking number 12. (this data is not captured)

alex
 
Ad

Advertisements

D

Douglas J. Steele

Check the "EnterKeyBehavior" property of the text box. You want it to be set
to "New Line In Field"
 
G

Guest

Also you can use CNTRL ENTER the same as Excel using ALT ENTER.

Douglas J. Steele said:
Check the "EnterKeyBehavior" property of the text box. You want it to be set
to "New Line In Field"

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


alex said:
Hello Experts,

I have a form in which users enter data.

On said form is a comment box that is tied to a table with a memo data
type in the applicable field. This arrangement seems to work until
the user presses enter or creates spaces in his/her text. It appears
that the table will only capture continuous text and noting else. Any
thoughts?

E.g., if the user types:

This case needs to be looked at. (this data is captured)
[space]
Please see tracking number 12. (this data is not captured)

alex
 
A

alex

Also you can use CNTRL ENTER the same as Excel using ALT ENTER.



Douglas J. Steele said:
Check the "EnterKeyBehavior" property of the text box. You want it to be set
to "New Line In Field"
Thanks for the response.

The text box propery was set to 'New Line in Field.'
If I continue to type text in the text box: the data are captured in
the table, no matter where the data lie in the text box .
As soon as I press enter (to start a new line): any data on any
subsequent line are not captured.
I thought maybe 'Can Grow' would work--no!
 
J

John W. Vinson

The text box propery was set to 'New Line in Field.'
If I continue to type text in the text box: the data are captured in
the table, no matter where the data lie in the text box .
As soon as I press enter (to start a new line): any data on any
subsequent line are not captured.

How are you determining if the data is "captured"? Looking in the
table datasheet?

If so, the second line of text is probably simply out of sight: put
the cursor into the datasheet and arrow right. Does the new line
spring into view?

If you're displaying it on a Form with a textbox large enough to view
multiple lines, it should be visible. "Can Grow" applies ONLY to
printing and won't make the textbox grow onscreen.

John W. Vinson [MVP]
 
Ad

Advertisements

A

alex

How are you determining if the data is "captured"? Looking in the
table datasheet?

If so, the second line of text is probably simply out of sight: put
the cursor into the datasheet and arrow right. Does the new line
spring into view?

If you're displaying it on a Form with a textbox large enough to view
multiple lines, it should be visible. "Can Grow" applies ONLY to
printing and won't make the textbox grow onscreen.

John W. Vinson [MVP]

You're right John; it was there, i just couldn't see it. Thank you
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top