Display Two Microsoft Access Fields on Separate Lines in a Form or Report
Question details
Show Facility Name and CCCE's Name on separate lines in an Access form or report.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- A user wants to select or display related facility information with each field on its own line.
- Observed behavior
- The desired result is a form or report that presents the two related fields on separate lines.
Identify the table or query containing Facility Name and CCCE's Name, and check how it relates to the form or report's data source. If a numeric facility key exists, use it to link the records.
Show the Selected Combo Box Fields in Separate Form Text Boxes
Use this approach when a form needs a combo box for selection and a reliable two-line display of the selected fields.
A calculated combo box field can contain a line break, but a standard Access combo box may not render it as multiple lines. Separate text boxes provide more predictable formatting.
Open the form in Design View, select the combo box, and use Property Sheet > Data > Row Source to include the facility key, Facility Name, and CCCE's Name, in that order.
In the Property Sheet, set Bound Column to 1 and Column Count to 3. Under Format, set Column Widths to 0";2";2" to hide the numeric key while showing the two names in the list.
Add two text boxes below the combo box. Set their Control Source properties to =[cboFacility].[Column](1) and =[cboFacility].[Column](2), replacing cboFacility with the actual combo box name.
Switch to Form View and select a facility from the combo box. Confirm that Facility Name and CCCE's Name appear in the two text boxes on separate lines.

Use a Joined Query and Separate Text Boxes in the Report
Use a report query and bound text boxes to display related fields with independent formatting.
Use WPS Office to Review Exported Access Data
WPS Office is a free, lightweight alternative with a familiar interface and support for common Microsoft Office formats, making it easy to work with exported data. It does not replace Access database forms or fix Access combo boxes and reports.

Frequently Asked Questions
Can an Access combo box show two fields on separate lines?
You can add a calculated field to its Row Source query using [Facility Name] & Chr(13) & Chr(10) & [CCCE's Name], but a standard combo box may not render the line break. For a reliable two-line display, place two text boxes on the form.
How do I hide the numeric ID in an Access combo box?
In Design View, select the combo box and open its Property Sheet. Set Bound Column to the key's column and set that column's width to 0 in the Column Widths property.
Why use text boxes instead of a combo box in a report?
Text boxes can bind directly to fields in the report's Record Source and can be positioned and formatted independently. Use a joined query as the Record Source to bring the related fields into the report.
What key should I use to join the facility records?
When available, join a numeric primary key to its matching foreign key. For example, an AutoNumber primary key typically pairs with a Number field whose Field Size is Long Integer.




