How to display lots of data on a single form?

[reginaldmerritt]

I hate putting to many controls onto one form. But this recent project i'm working on requires a control which displays parts of an address. Along with the other controls on the form there is little space to display this address in its entirty.

I was wondering what options where avalible. I'm using a continuous form and a combo box to select an address. I have already cut down the address to just show "Company"\"Room "\"Street"\"Tow n".

Is it possible to strech out the display of a combobox longer than the controls actual length?

If not can MouseOver be used to open an close a popup form to act like a kinda zoom option?

Don't know where to start looking for this, any suggetions are welcome. Sorry its not a more specific question.

[malcolmk]

I beleive that setting the row width in the combobox property has no bearing on the size of the combobox on the form. You can adjust width on the form to show only company name, when clicked the drop down can be the whole width of the screen if you want up to a maximum width of 22 cm.

[reginaldmerritt]

Wow malcolmk your right.

I assumed row width was the width of the combo box.

Assumption can be a teribble thing, obvious now you have pointed it out.

Thank you very much for your help.

[Megalog]

FitCombo function

With some easy modification, you can change the width of the drop-down window, without changing the control's size.

See the attached database for an example form with two combo boxes. One is standard, one is modified to fit it's content. The modified combo box has a function call when you enter the control, that resizes it's content.

If you have any questions let me know. I use this in a lot of my dbs.