How to Use the Displayed Combo Box Value in a Microsoft Access Email Subject
Question details
The user needs a Microsoft Access email subject to show the Practice ID and treatment-center name displayed in a combo box, rather than the hidden bound key returned by the Value property.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- The user is building or editing an Access email workflow and wants the email subject line to use the human-readable combo box value.
- Observed behavior
- The email subject returns the hidden key from the combo box Value property instead of the displayed Practice ID.
Open the Access form in Design View, identify the combo box name, such as cb_Choose_Practice_ID, and confirm which visible column contains the Practice ID and treatment-center name.
Use the Combo Box Column Property Instead of Value in the Email Subject
Use this when the email subject line shows the hidden key and you need the displayed Practice ID or treatment-center name.
An Access combo box can store a hidden bound key while displaying more user-friendly columns. The Value property returns the bound column, so the email expression must reference the visible column directly.
In Microsoft Access, open the form containing cb_Choose_Practice_ID, and go to the event or macro that creates the email subject line.
Change the expression to reference the combo box Column property instead of Value. For example, use: "Clinic Sheets for Practice " & Me.cb_Choose_Practice_ID.Column(1).
Verify that the Practice ID is in the second visible combo box column. Access column numbering is zero-based, so Column(1) refers to the second column.
Save the form or module, run the workflow, and check that the email subject now shows the Practice ID instead of the hidden key.

Manage Office Data Without Access Complexity in WPS Office
WPS Office is a free, lightweight Microsoft Office alternative with a familiar interface and high compatibility, so you can handle everyday data and document tasks without relying on complex Access forms.
- 1. Download WPS Office: Visit the official WPS Office website and click Download WPS Office Free to install WPS Writer, Spreadsheet, and Presentation.
- 2. Open your existing Microsoft Office files: Launch WPS Office and open your .docx, .xlsx, or .pptx files directly. For Access data, export the table or query to Excel from Microsoft Access first.
- 3. Manage your data in WPS Spreadsheet: Use WPS Spreadsheet to sort, filter, and track data without maintaining an Access combo box form.

Frequently Asked Questions
Why does my Access email subject show the hidden key instead of the displayed Practice ID?
Because the expression uses the combo box Value property, which returns the bound column. Reference the visible column with the Column property, for example Me.cb_Choose_Practice_ID.Column(1), to return the displayed Practice ID.
How do I reference a specific column in an Access combo box?
Use the combo box name followed by .Column(n). Access uses zero-based numbering, so .Column(0) is the first column, .Column(1) is the second, and so on.
Does WPS Office include Microsoft Access?
No. WPS Office does not include an Access database application or run Access VBA forms. You can open and edit documents created in Word, Excel, and PowerPoint with WPS Writer, Spreadsheet, and Presentation.
What can I use in WPS Office instead of an Access combo box form?
For many data tasks, you can manage data in WPS Spreadsheet, use lists or data validation, and export Access data to Excel-compatible files when you do not need a full relational form.




