Others

Display Two Microsoft Access Fields on Separate Lines in a Form or Report

Chanuka GeekiyanageChanuka Geekiyanage Nov 22, 2026 868 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Set the combo box source

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.

2
Configure the columns

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.

3
Add the field displays

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.

4
Test the selection

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.

Show the Selected Combo Box Fields in Separate Form Text Boxes
About line breaks inside the combo box: You can test a calculated field such as [Facility Name] & Chr(13) & Chr(10) & [CCCE's Name] in the Row Source query, but the combo box may not display the break as a second line.
Free Microsoft Office alternative

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.

Review facility data exported from Access in a spreadsheetCompatible with Microsoft Excel XLSX, Word DOCX, and PowerPoint PPTX filesFamiliar spreadsheet interface for a smoother move from Microsoft OfficeFree, lightweight tools for everyday document work
microsoft office alternative - wps office

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.