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

List Boxes

P: 38
I have a big problem and would appreciate any help! I have an Access 2003 Database and I have forms in the database that have many list boxes. I only have one table that is a link and many queries that run off that table. I have somewhere around 50 list boxes in each form. Recently all list boxes have lost their format and are now just showing numbers rather than percentages. I check the row source and made sure it was formatted to percent and it was. The query shows it as a percent; however, the list box does not. Can someone please help. I have even tried to create a new list box, but it does the same thing. I am also having a problem with my combo boxes, they are bound to a query and when I look at the query it shows the correct information, but when I try to use click the combo box it's unreadable. Meaning the information is there you just can't see it. I tried to change the text color thinking that was the problem, but it's still completely white and unreadable.
Aug 15 '08 #1
Share this Question
Share on Google+
5 Replies


Expert Mod 2.5K+
P: 2,545
Hi freddie1437, and Welcome to Bytes!

Taking your combo issue first, this is a known (and very annoying) bug with Access. It relates to tables where the format of the field has been set to uppercase. Find the table from which your combo's blank field is taken, bring up the table properties, select the field concerned, and remove the force uppercase symbol '>'.

The percent formatting problem is not an issue I know of at present I'm sorry to say. It is normal to apply the formatting to the control, not the underlying query as such - so is percent formatting applied/available for listboxes? I don't use listboxes for numerics this way, so all I can do is suggest you check that the listboxes are formatted correctly.

-Stewart
Aug 15 '08 #2

P: 38
These are linked tables so how can I change the property? They are linked through Excel will that be a problem?

As for the list boxes, you can't change the property in the list boxes right? The query works great, but not the list boxes. Do you suggest I use a different format other than List boxes? What would you do?

Thank you!
Aug 15 '08 #3

Expert Mod 2.5K+
P: 2,545
Hi. The format property is available for linked Excel tables as well, so try the solution from the previous post.

I checked and found that list boxes cannot be set to a specific format, but comboboxes can. I'm not sure why you need so many listboxes which display data on a form - the norm is to use textbox controls unless you want users to select from a list of items.

If you do need to display lists with formatted percentages you can try using comboboxes instead.

-Stewart
Aug 15 '08 #4

missinglinq
Expert 2.5K+
P: 3,532
More so than the "why" it's necessary to have 50 listboxes on a form, the "how" of having that many on a single form intrigues me! What are these listboxes being used for?

BTW, while using the > sign to force uppercase is usually sited as the culprit when SP3 without the hotfix causes data to "disappear" from comboboxes/listboxes, the cause is actually anything in the format property.

Linq ;0)>
Sep 4 '08 #5

P: 38
More so than the "why" it's necessary to have 50 listboxes on a form, the "how" of having that many on a single form intrigues me! What are these listboxes being used for?

BTW, while using the > sign to force uppercase is usually sited as the culprit when SP3 without the hotfix causes data to "disappear" from comboboxes/listboxes, the cause is actually anything in the format property.

Linq ;0)>
Well I have a linked table coming from excel. So I just want my form to show percentages and totals. Is there an easier way?
Sep 4 '08 #6

Post your reply

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