Memo Data Type

[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

 

[Douglas J. Steele]

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

 

[Guest]

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

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!)

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

 

[alex]

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

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!

 

[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]

 

[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