issue - blank columns in my look-up tables/combo boxes

R

Remp

I am creating just creating my own database but I am having problems with
combo boxes. Although all columns are there only some have data shown in them
yet I know there is data there, it is just not displaying it in the drop
down. Why is this?

Thanks for any help you can give.
 
D

Dale Fye

What version and release of Access are you using. I'm running 2007, so I'm
not sure these instructions will be right. If you are using 2003, click the
Help - About menu items and then record the version and the SP that is
displayed in that box.

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.
 
J

John W. Vinson

I am creating just creating my own database but I am having problems with
combo boxes. Although all columns are there only some have data shown in them
yet I know there is data there, it is just not displaying it in the drop
down. Why is this?

Thanks for any help you can give.
Click to expand...

Probably because of some error - which we cannot see from here! - in the
properties of the combo box. Please post the following properties of one of
the affected controls: Control Source; RowSource (post the SQL view of the
query if it's a query, the relevant fields if it's a table); Column Count;
Bound Column; Column Widths.
 
R

Remp

Hi, I am using Access 2003 with SP3 on Vista.
I have had this issue with 2 combo boxes today.

The simplest one was when I was trying to link a 'country' list table to a
customer data entry field using a look-up wizard. I had two fields in my
country table, unique id (autonumber) and then the county name ( eg UK,
France etc). i was just trying to get the country names to appear in a drop
down list so at the data entry point in a form. However, every time I linked
the tables together it would only show me the Id no or blank lines in the
drop down, although when i cliked on a line, it would put data into the form.
It is as though the data is there in the list but i just can't see it till i
make a slection into the field.

The second occurance has been when I tried to create a 'Find' box on my
form. I set it up to show 5 columns but two columns showed blank entries
even though the rest of data in the other columns was there. Again, if i
actually selected a line, it would find me the correct table entry. The ext
is just not showing.

I am just using the wizards to set these things up ( I am just a beginner
with Access) so i didn't think I was making any selections which would casue
me this issue.

Any help? Thanks.
 
R

Remp

Hi, I have downloaded the hot fix, do i need to do anything else as it does
not seem to have fixed my problem? Or do I need to rebuild the combo boxes to
get them to work?

Thanks,
 
R

Remp

Row Source Type: Table/Query
Row Source: SELECT [Customer Data].[Customer Number], [Customer
Data].Surname, [Customer Data].Firstname, [Customer Data].[email address],
[Customer Data].Postcode FROM [Customer Data];
Column Count: 5
Column Heads: Yes
Column Widths: 0cm;2.355cm;2.54cm;3.969cm;2.54cm
Bound Column; 1



Customer Data
Surname Firstname email address Postcode
HASTINGS KATIE [email protected] Lincs
PRYOR MARCELLUS [email protected] 74170
HASTINGS SANDY [email protected] PE22 0TD

This is what I was trying to see in my 'Find'combo box, but I don't see the
data in the first two columns although I do see the columns.
Thanks,
 
D

Douglas J. Steele

At the risk of seeming condescending, did you run the hot fix, or just
download it?

If the cause of your problem was the bug introduced to combo boxes in Access
2003 by SP3, installing the hot fix is all that should be required: no
rebuilding should be necessary.
 
P

pcbins

I have installed that "fix" and it doesnt fix all my combo boxes. Is there a
fix for the fix?
 
D

Douglas J. Steele

Are you sure you installed the fix?

When you click on the file you downloaded, it asks for a folder to extract
the files. Once you've done that, you need to go to that folder and actually
run the fix.
 
P

pcbins

I know the combo box is working because the numeric columns appear. Only the
Text columns do not show.
But I will try to get that information for you... when I am not too busy
running from PC to PC trying to get Micros#!t Office SP3 off all these
computers...

Remp said:
Row Source Type: Table/Query
Row Source: SELECT [Customer Data].[Customer Number], [Customer
Data].Surname, [Customer Data].Firstname, [Customer Data].[email address],
[Customer Data].Postcode FROM [Customer Data];
Column Count: 5
Column Heads: Yes
Column Widths: 0cm;2.355cm;2.54cm;3.969cm;2.54cm
Bound Column; 1



Customer Data
Surname Firstname email address Postcode
HASTINGS KATIE [email protected] Lincs
PRYOR MARCELLUS [email protected] 74170
HASTINGS SANDY [email protected] PE22 0TD

This is what I was trying to see in my 'Find'combo box, but I don't see the
data in the first two columns although I do see the columns.
Thanks,


John W. Vinson said:
Probably because of some error - which we cannot see from here! - in the
properties of the combo box. Please post the following properties of one of
the affected controls: Control Source; RowSource (post the SQL view of the
query if it's a query, the relevant fields if it's a table); Column Count;
Bound Column; Column Widths.
Click to expand...
Click to expand...
 
Top