Pain in the a** Combo Problem

  • Thread starter Thread starter Pete
  • Start date Start date
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
 
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.
 
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
 
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
 
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?
 
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
 
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?
 
Back
Top