By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,576 Members | 1,360 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,576 IT Pros & Developers. It's quick & easy.

Change Field Name on a ComboBox

P: 4
I have a reports that I need to reword:

Billable Hours by Employee
Billable Hours by Project
Employee Address Book
Employee Phone List
Non-Billable Hours by Employee

I have a combo box that shows these reports and a button that opens up the reports I selected.

I want to change the wording a little bit to show in the combobox

Hours Worked by Employee
Hours Worked by Project
Employee Address Book
Employee Phone List
OT Hours Worked by Employee

I have changed my reports to reflect the name change, but I just don't know how to update my combobox. Is there any way to keep the orignal report information in the combobox, but display the name differently in the combobox?

I can always email you a copy of my database if you'd like to play around with it.

Thanks!
Mar 13 '14 #1

✓ answered by NeoPa

Select the report in your database (not the shortcut but the report itself). Rename it.

There are many ways to rename an object. I'm surprised you would need to ask about that. One is to use the F2 key. Another is found from a list after right-clicking on the object. There's another option from the menu or ribbon that I'm not familiar with as the other methods are so much easier.

Share this Question
Share on Google+
6 Replies


zmbd
Expert Mod 5K+
P: 5,397
Please do not attach nor send your database unless one of the experts/moderators/admins ask for it.

What we need to see is the base information behind your combobox control.
Open the form in design view
Right click the combobox in question.
Select Show Properties in the popup
Select the data tab
What we need is the information in the following property fields:
Control Source:
Row Source:
Row Source Type:
Bound Column:

We may need more detail about Row Source depending on your answers.
Mar 13 '14 #2

P: 4
Thank you for responding ZMBD!

I have to warn you, I'm not very knowledgable in ACCESS. This is what I show in the database that I'm using.

Control Source: Is Blank
Row Source:
Expand|Select|Wrap|Line Numbers
  1. SELECT MSysObjects.Name
  2. FROM MSysObjects
  3. WHERE (((MSysObjects.Name) Not Like "*Subreport*")
  4.   AND ((MSysObjects.Type)=-32764))
  5. ORDER BY MSysObjects.Name;
Row Source Type: Table/Query
Bound Column: 1

Thanks again for your help!
Mar 13 '14 #3

NeoPa
Expert Mod 15k+
P: 31,769
If the reports are already renamed then your existing code (.RowSource) should now produce a list to match that.
Mar 14 '14 #4

P: 4
Thank you for your help NeoPa and your patience. I think I renamed the shortcut to my report but haven't actually renamed the reports. Is it possible for me to rename an existing report? If so, how would I go about doing it? Thanks again!!!
Mar 14 '14 #5

NeoPa
Expert Mod 15k+
P: 31,769
Select the report in your database (not the shortcut but the report itself). Rename it.

There are many ways to rename an object. I'm surprised you would need to ask about that. One is to use the F2 key. Another is found from a list after right-clicking on the object. There's another option from the menu or ribbon that I'm not familiar with as the other methods are so much easier.
Mar 14 '14 #6

P: 4
NeoPA, THANK YOU, THANK YOU, THANK YOU, THANK YOU!!!! Thanks to your help, I was able to get it figured out. You're a life saver! And great and prompt responses! I really appreciate your help and patience with me!!! Thanks again!!!
Mar 14 '14 #7

Post your reply

Sign in to post your reply or Sign up for a free account.