Table like word ? Simple question

[Jack]

Hi

I'm new to access and have designed a database for a customer. It is fine,
only problem is that they want text fields to be possible to expand to
second line like a table in word which they were used to.

I don't know how to do this, when they hit enter it proceeds to the next
field and not to a new line in the same field. He says that this should be
possible.

It is access 2003

Thanx

Jack

 

[Arvin Meyer [MVP]]

In the property sheet for the textbox, set the vertical scroll bar to be on,
then change the Enter Key Behavior (on the Other tab) to:

New Line in Field

That should do it. The physical size of the textbox in the form will not
change, but you will be able to get multiple lines in. For reports, set the
Detail section and the textbox CanGrow property to Yes.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Jack]

This is working fine for a report, that is I have to make the field bigger,
would be nice not to if there weren't extra data in the field.

Can I make it expand in the query window?

If I make a form it's only showing the actual record, they need to see more
at a time and beeing able to change the content. As I can see I can only get
this to work in the query window. Can I make a form showing more records at
a time ?

Jack

 

[Larry Daugherty]

Try this: Open the form in Design view and change its Display
property to Continuous.

Otherwise, your description of the problem/desired outcome is
unclear...

HTH