Free Text In A Report?

[Paperback Writer]

I need to be able to type free text into a report. When I use a text box, I
can type in it, but when I hit "return" ("enter" on some keyboards) to go to
the next line, it doesn't allow me to do so.

Is there a way to type in a few sentences of free text right into a text box
(or some other box), and have it work like a basic word processor (notepad)?

 

[Douglas J. Steele]

Check the value of the text box's EnterKeyBehavior. You want it to be New
Line In Field.

 

[hor vannara]

Hi

You coud base your report on a form. Add an unbound text box (memo
format)
and type what you want into that. Don't forget to set the value of the
memo
back to "" when yo have finished - you could use the closeing of the
report
to do this (don't do it on open or you will not get the content into the
report.

If you want a line return in the memo box just press Shift/Enter or you
can
write a little code (onKeyPress) whilst the box has the focus

 

[Paperback Writer]

When I go to the property sheet for that textbox, I do not see an option
called "EnterKeyBehavior." Where is that located?

 

[Douglas J. Steele]

You should be able to find it on the Other tab.

 

[Paperback Writer]

I use Access 2007. I can't find it there.

You should be able to find it on the Other tab.

 

[Douglas J. Steele]

Sorry, I don't have Access 2007 installed on this machine, so I can't
double-check.

Hopefully someone else will see this and chime in.