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.
5 1296
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
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!
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
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)>
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?
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Dwayne Gaddy |
last post by:
Hey all,
I have a windows form with a list boxes. I have data bound the list boxes
with data from my sql database. I want to use drag and drop to allow users
to choose different options from the...
|
by: chris vettese |
last post by:
I have a table called table1 that has a one to many relationship to
table2. What I would like to do is have a form with two list boxes on
it. The first list box will have a field from all of the...
|
by: Galina |
last post by:
Hello
I have 6 dependent list boxes on my ASP page:
Faculty;
Lecturer;
Course;
Course occurrence;
Group;
Week commencing date.
When faculty is selected, lists of lecturers and...
|
by: Kay |
last post by:
Hello,
I have two list boxes on my form, one initially displays with items and the
other displays blank, by clicking a button, it is possible to move items
from one box to another and vice a...
|
by: Yoshitha |
last post by:
hi
I have 2 drop down lists in my application.1st list ontains itmes like
java,jsp,swings,vb.net etc.2nd list contains percentage i.e it conatains the
items like 50,60,70,80,90,100.
i will...
|
by: Vigneshwar Pilli via DotNetMonster.com |
last post by:
string connectionString1 = "server=(local); user=sa;password=sa;
database=sonic";
System.Data.SqlClient.SqlConnection dbConnection1 = new
System.Data.SqlClient.SqlConnection(connectionString1);...
|
by: ljungers |
last post by:
Have Form-1 with 3 text boxes and 1 command button. With any of the 3 boxes filled out and button is clicked, a Macro is performed that Opens a Query that has a WHERE clause that uses the 3 test...
|
by: ljungers |
last post by:
I'm on the home streach of my project and found that my "Reset for New Search" command button not working as desired. What should happen is that when the button is clicked a Event Procedure is run....
|
by: Rabbit |
last post by:
Cascading Combo/List Boxes
This tutorial is to guide you in the creation of Cascading combo/list boxes. That is when you have multiple combo/list boxes where the selection of an option in one...
|
by: hollinshead |
last post by:
hi there, i have been having this issue for quite some time now and i cant seem to get my head around it. I am trying to create a database for candidates CV's and covering letters. basically the data...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |