Invisible text

[Matt]

I will start out saying I am using Windows XP sp2 with Access 2003 sp3.

I created a query that shows up fine in the query view but when I use it in
my form the text is invisible. In my combo box I click on the drop down
arrow and cannot see the text. I can scroll through and select a line. I
cannot see what I am selecting until clicking on it and it appears in the
box. It is then that I can see it.

I did not make any font changes in my form or query. I entered a different
query and it showed up fine. Why is this one different? I have not used any
VB code.

What am I doing?

Thanks

 

[Ken Snell [MVP]]

Does the combobox control (or the field to which it's bound) have a value in
the Format property? If yes, you've been bitten by a new bug introduced by
Office 2003 SP3 package. You'll need to apply a hotfix:

Description of the Access 2003 post-Service Pack 3 hotfix package:
December 18, 2007 - 945674

http://support.microsoft.com/kb/945674

 

[Jeanette Cunningham]

Matt, this is the same answer I gave you to the same question on the day
before on this same discussion group. Did it help?

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

Does the combobox control (or the field to which it's bound) have a value
in
the Format property? If yes, you've been bitten by a new bug introduced by
Office 2003 SP3 package. You'll need to apply a hotfix:

Description of the Access 2003 post-Service Pack 3 hotfix package:
December 18, 2007 - 945674

http://support.microsoft.com/kb/945674

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

 

[Matt]

Sorry if it posted twice. I had been receiving errors from this site and
each time I tried posting something it would not go (showed "unavailable").
I will try this now and get back to you.

Thanks
--
73,
Matt

Matt, this is the same answer I gave you to the same question on the day
before on this same discussion group. Did it help?

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Matt]

OK I will try this from home this time. I am having trouble trying to post
at work in the middle of the night. Keep getting "unavailable" errors and it
is not from the work filters (I checked).

So I wanted to let you both know that I looked into the Format property for
my query and table that I am using for this form and as the control. I
cannot find it. Am I missing something?

I am going to apply the hotfix anyway as soon as I can get with IT. I need
admin privileges to do it. Unfortunately there is no one that knows Access
to help.

I'll get back here after this is done. Thanks.
--
73,
Matt

Matt, this is the same answer I gave you to the same question on the day
before on this same discussion group. Did it help?

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Ken Snell [MVP]]

You cannot find the Format property?

For a table's field, open the table in Design view. Click on the field. At
bottom of screen, you'll see a box labeled Format.

For a form's control, open the form in Design view. Click on the control.
Open the Properties window (via Propertiec icon button on toolbar). Click on
Format tab. You'll see a box labeled Format at the top of the list.

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

 

[Matt]

I knew where it was on the form. I see it now for the table.

 

[Matt]

Ken,
I do not have anything in the FORMAT field on either the form, or table. I
am using a query to populate the combo box. Is there something I may be
doing wrong there? It is only 1 column of information that is being used. I
did nothing special in creating the query.

Thanks
--
73,
Matt

You cannot find the Format property?

For a table's field, open the table in Design view. Click on the field. At
bottom of screen, you'll see a box labeled Format.

For a form's control, open the form in Design view. Click on the control.
Open the Properties window (via Propertiec icon button on toolbar). Click on
Format tab. You'll see a box labeled Format at the top of the list.

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

 

[Ken Snell [MVP]]

Post the properties of the combo box:

BoundColumn
RowSourceType
RowSource
ColumnCount
ColumnWidths

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

 

[Matt]

properties of the combo box:

BoundColumn - 1
RowSourceType - table/query
RowSource - incidentclass query
ColumnCount - 2
ColumnWidths - 0.0007";1"

Found it!!! Your request was the key. I changed the column count to 1 and
there it was! Thanks for your patience Ken.

 

[Ken Snell [MVP]]

Be sure that you also changed the ColumnWidths property to something like
1"

But then, if you now see the dropdown list, you must have done that already
< grin >.

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/