Part number combo box is blank, all others work

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Barry - 30 Nov 2007 02:12 GMT

I've tried repeatedly to make a part number combo box work. All other combo
boxes on my form work, but for some reason this one will not. I have tryed
to use this field in other forms (by itself) to try to figure it out, it
doesn't work on the others either. Could there be something in the table or
part number field?

Please help
dumb-founded LOL!

Reply to this Message

Linq Adams - 30 Nov 2007 02:48 GMT

We need to see your code assigning the cbo value and know whether your Part
Number is an actual Numeric datatype of Text datatype. Also, what
version/service pack of Access are you running?

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Reply to this Message

Bob Quintal - 30 Nov 2007 23:27 GMT

> I've tried repeatedly to make a part number combo box work. All
> other combo boxes on my form work, but for some reason this one
[quoted text clipped - 5 lines]
> Please help
> dumb-founded LOL!

The Office service pack released in mid-September messes combo box
displays if there is a format set on a field in the table.

This may be your problem,

A "fix" is to concatenate the part number with the empty string ""
in the combo box's row source

Signature

Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Reply to this Message