Combo Box help

[Gary W. Graley]

Hello folks,
I've started a database in Access 2003, on the entry form I have two fields
that should be visible to the user, the left most column is the kept field that
is written to the table once it's selected, the right column holds more detail
to help verify your selection.

All is well and good.....only when I view the database!

I've sent it to several engineers to check things out before I continue
but when they view the database, the first column appears blank!!!

BUT, if they choose one record in the combo box, THEN the first column
value will appear when they move from that field.

HELP, this is very strange to me and slightly disturbing of course!

Appreciate your help, let me know if there are any thing you guys/gals
would need to know regarding this setup.

Thanks,
G2

Edited to add:
ok I did a search and found an old thread that speaks to this problem
seems it's related to a Service Pack 3 bug Hotfix and I guess
this will correct it.
G2

 

[Dennisk]

You may have a Lookup (combo box ) specified at table level, which is not pointing to the correct records anymore. If so remove it and retain you combo box on the form.

 

[Gary W. Graley]

The problem is it works on my system, but not the other guys' systems, so I'm thinking
it's tied to an update problem in the service pack, my service pack is at a lower build
than the one engineers and that may make this happen?

But I appreciate that reply, that will be something to keep watch for in the future!
G2

 

[missinglinq]

Yes, I suspect that's exactly right! This is a problem specific to Access 2003/SP3. The cause is that the missing field has formatting applied somewhere. This cam be a simple as the > symbol used to force uppecase. You can resolve it by removing all formatting to the field, but the definitive fix is the SP3 hotfix, which you've already discovered.

 

[Gary W. Graley]

Thanks, we did the update with the hotfix and that solved the problem nicely
They did request the > formatting, so that was in there and needed, while I'm not
a fan of that, all caps just goads me, my old typing teacher said that all caps is
a sign of a lazy typists man, that was a few years ago!
My friend and I had to beg to be let into the typing class, rural farm area, back in
1972 wasn't a normal thing for boys to be taking typing class, but we perservered
and were allowed in, which helps today of course and for college back then as well !
plus, you're in a class with all girls didn't hurt much either
G2

 

[missinglinq]

Glad you got it fixed!

We're much of an age; I graduated from high school in '68. It's kind of mind-boggling at times, thinking back to the way things were! We had a female classmate who had to threaten to sue the school board in order to be allowed to take shop class! Today she owns a very successful general contracting company!

Cheers!

Linq