look up wizard

[Guest]

I have been using the lookup wizard, and I realize that some of the options
that go in it do not fit, is there a way to increase the size where I write
my options. It's called the "row source".

Miguel

 

[tina]

if you're adding a Lookup *field* to a table, recommend you don't. see
http://www.mvps.org/access/lookupfields.htm for reasons why not.

if you're creating a combo box control in a form, please explain what you
mean by "some of the options that go in it do not fit".

hth

 

[Guest]

If I understand you correctly, the columns that display on the form in a
combo or list box that uses a lookup wizard are not large enough to show all
of the data. If this is your problem, try double click between the columns
when you get a double headed arrow.

 

[Guest]

Tina and Jennifer:
One field ( option combo box ) has 8 options which were created from a
lookup wizard. Two of these options have large characters that do not fit in
the lookup wizard completely so when the list of options is dropped down I
can see that two of the choices are not completely shown in the list
(partially only). I wonder if there is a way to increase the size so the
whole choice in the combo box appears in the lookup wizard.
Miguel

 

[tina]

sorry, Jennifer, that won't work. columns in a combo box and listbox control
are "fixed", and can only be changed by changing the values in the
ColumnWidths property - either manually or programmatically.

hth

 

[tina]

in a form's combo box control, you can control the width of each column in
the ColumnWidths property. for instance, if you have three columns that are
each one inch wide, as

ColumnWidth: 1"; 1"; 1"

and you want to make the second column 2 inches wide, then change the
property, as

ColumnWidth: 1"; 2"; 1"

again, you should be doing this in a combo box control at the form level.
creating Lookup *fields* in a table is a bad idea.

hth

 

[Guest]

Is this a form you are working on? If it is, switch to design view of the
form and widen the combo box from there. Either use the properties for the
size or click and drag it wider using the sizing handles.