Need to force 2 lines in cell

[Don]

In both form & report I need to be able to expand cell to accomodate two
lines of print, eg., street address above city,state & zip in same
cell.....is this possible in Access and, if so, how do I do it??

 

[Gina Whipp]

Don,

All you need to do is go into Design View, highlight the field and go to the
bottom, and expand it OR you in the Report you could jjust set the field to
Can Grow = Yes. Or did you need to know how to get Address, City, State and
Zip in the field?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Steve]

There should never be a need to do this. The table containing this data
should have four separate fields for StreetAddress, City, State and Zipcode.
In a form, each field needs to be separate for data entry.Typically a query
is used as the recordsource for a report contaning this
information.StreetAddress is a separate field and City, State and Zipcode
are concatenated into one field. StreetAddress can then be a separte textbox
and CityStateZip can be another textbox directly below the StreetAddress
textbox. In a form where you only want to display the data (no data entry),
the same construct is used the same as for a report.

Steve
(e-mail address removed)

 

[John W. Vinson]

In both form & report I need to be able to expand cell to accomodate two
lines of print, eg., street address above city,state & zip in same
cell.....is this possible in Access and, if so, how do I do it??

In a Form, just make the textbox big enough for as many lines as you want.
In a Report, set the textbox's Can Grow property to Yes (there must not be any
other textbox horizontally next to this textbox).

You should have the address, city, state and zip in separate fields in your
table, and ordinarily they'd display in separate textboxes; if for some reason
you need to enter multiline data in one field (that's *field*, not *cell* -
Access doesn't have cells!!!), you can type

FirstLine <Ctrl><Enter>SecondLine

or you can concatenate two fields into two lines in a control with an
expression like

FirstLine & Chr(13) & Chr(10) & SecondLine

in the Control Source of a textbox or in a vacant Field cell in a query.