Pain in the a** Combo Problem

P

Pete

Hi I have a combo and it keeps on putting the data on two
lines I have made its width bigger but it still does it.
How do I make sure it doesnt do this?

Thanks

Pete
 
D

Duane Hookom

Thanks for sharing information about your combo box ;-)

What are the following properties:

Row Source Type:
Row Source:
Column Count:
Bound Column:
Column Widths:

I expect that you simply need to change the column count but it's a bit
difficult to see your mdb from here.
 
P

Pete

Row Source Type: Table/Query
Row Source: qrycbonames
Column Count: 2
Bound Column: 1
Column Widths: 0cm;4.932cm

The column width of 4.932 is more than enough for all of
the entries.

Sorry about the double post

Thanks for your help.

Pete
 
P

Pete

One more thing

Its really strange how it does it but some of the longer
entries go on one line and some of the shorter entries
dont !!

Thanks again
 
D

Duane Hookom

I have never seen a combo box that "puts data on two lines". Are you seeing
this when the combo box is dropped down?
What do you see when you view qrycbonames in datasheet view?
Is it possible that you have embedded CrLfs in the values?
 
P

Pete

Maybe I have does the sign of / make any difference?

let me give you an example of the data

this fits on one row in the cbo

BADGER HILL FIELD LN/DTK
this does not
BANK HOUSE/SPS

hth
 
D

Duane Hookom

I still don't know where you are seeing two rows.
Again, is this when the combo box is dropped down?
Again, what do you see when you view qrycbonames in datasheet view?

If you add a new combo box to your form and use the wizard and same row
source, does this issue repeat?
 
Top