ACCESS FEED: RE: [MS_AccessPros] Combo to Text

Kamis, 28 Januari 2016

RE: [MS_AccessPros] Combo to Text

It would be a lot easier if you provided the names of your comboboxes and the control sources used on your report that should display their values.

Add two more text boxes on your form that already has your combo boxes. Set the control sources of these two new text boxes to reference the Column() property of the comboboxes

=YourComboBox1Name.Column(1)

When you look at these in form view they should reflect the text value like "Bill".

Then change the text boxes on your report so their control sources reference the new text boxes rather than the old combo boxes. You can make the text boxes on the form invisible.

Duane Hookom, MVP

MS Access

To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Thu, 28 Jan 2016 17:12:55 -0600
Subject: RE: [MS_AccessPros] Combo to Text

Duane,

I wish I could follow you but I am not quite smart enough. I think I need a few more details to help me understand. I am not quite able to understand the concept.

Thanks,

Bill

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, January 28, 2016 4:57 PM
To: Access Professionals Yahoo Group <ms_access_professionals@yahoogroups.com>
Subject: RE: [MS_AccessPros] Combo to Text

You can add text boxes (invisible) with control sources of:

=cboBoxName1.Column(1)

=cboBoxName2.Column(1)

Then, in the report, use the names of the text boxes rather than the names of the combo boxes.

Duane

To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Thu, 28 Jan 2016 15:08:55 -0600
Subject: [MS_AccessPros] Combo to Text

I have a few unbound fields on a form. Once the fields are filled in the user can click a button and a report opens with some of the fields already populated with the text from the unbound fields on the form. It was actually working pretty good until I changed a few of the unbound filed to Combo boxes. Now the user selects a value from the combo box. However when the report is opened I am getting an error, which I expected. What I want is to still show the text attached to the number behind the combo box.

So agent 2 is Bill, based on the table the combo box uses, If "Bill" is selected from the combo box, I know the value the combo box is holding is "2" which is what I want, but is there any way to open a form and pull the text "Bill" rather than the value 2?

There is no query or table behind the form as I do not want to store the values there. The unbound field will also be use to append some of the data to other tables, which is why I need the combo boxes, as that matches the data type of the table the data may be moved to.

Thanks,

Bill

Access 2013

Minnesota, USA

__._,_.___

Posted by: Duane Hookom <duanehookom@hotmail.com>

Reply via web post

•

Reply to sender

•

Reply to group

•