Invisible text in drop down parameter query

[trawets]

Hi
Don't know if the subject is explanation or not for what Ive got
but here goes

I have been trying to build parameter queries with drop down list
combo boxes using the following tutorial
http://
www.fontstuff.com/access/acctut08.htm#dialog
my platform is Access 2003
all was going well until I run the form with combo boxes, I can run
query OK

but when I choose from my drop-down lists no text is visible until I
click in the list and then the selection is visible, I tough this must
just be a font color problem, but I cant seem to make a difference to
it as I say I can select and then see the choice but have to guess on
what I'm choosing, weird
I am sorry if this is just a daft mistake but it hard to find for me
anyhow

 

[John W. Vinson]

but when I choose from my drop-down lists no text is visible until I
click in the list and then the selection is visible, I tough this must
just be a font color problem, but I cant seem to make a difference to
it as I say I can select and then see the choice but have to guess on
what I'm choosing, weird
I am sorry if this is just a daft mistake but it hard to find for me
anyhow

Sounds like there's a conflict between the ColumnWidth property and the
RowSource. This would happen if the first nonzero width column in the row
source query is NULL.

Check the RowSource property - open it as a query. What field do you want to
see when the combo is not dropped down? Note its sequential position in the
query - e.g. the second field, the third field.

Then check the ColumnWidths property. It should be a string of numbers
separated by semicolons, representing the width on the screen of each field in
the query. Be sure that the values of the columns you DON'T want to see are
all 0, and that the width of the column you *do* want to see is nonzero. If
necessary, rearrange the columns in the query so that the first nonzero width
column is the desired one.


John W. Vinson [MVP]

 

[trawets]

Sounds like there's a conflict between the ColumnWidth property and the
RowSource. This would happen if the first nonzero width column in the row
source query is NULL.

Check the RowSource property - open it as a query. What field do you want to
see when the combo is not dropped down? Note its sequential position in the
query - e.g. the second field, the third field.

Then check the ColumnWidths property. It should be a string of numbers
separated by semicolons, representing the width on the screen of each field in
the query. Be sure that the values of the columns you DON'T want to see are
all 0, and that the width of the column you *do* want to see is nonzero. If
necessary, rearrange the columns in the query so that the first nonzero width
column is the desired one.

John W. Vinson [MVP]

hi John
Thanks for the reply this may sound a bit dafter than the original
question, but this is how it is at the moment, my work machine now has
access 2007 that the guys put on over the weekend and now problem has
gone away all is well, weird or what.

I suppose Ill have to bring a copy home and see if its still a
problem, but thanks for now anyway,
very best regards
Stewart