No can shrink property of a drop down control

[Bert]

Hi All,
I have a report that shows the people and the machines they have, but the
machines listed come from a drop down & I cannot see how to shrink this
control if they do not have that machine.
So I have a person with 2 machines, another with 6 machines etc. the report
always shows all
Any suggestions are welcome
thanks
Bert

 

[Eric Blitzer]

Delete the control and add an unbound text box. Then set the control source
to the filed in question. You will be able to set the grow and not grow.

 

[Bert]

Hi Eric,
Not sure if that will work - The report is from a table that is already
filled in & should not be changed, just want to not show the machines when
blank

Thanks Bert

 

[Eric Blitzer]

I did not mean delete the field from the table but from the form and add an
unbound control and make the control source from the table(Field Machine).
resize the control so it appears like a line. Set can grow property to "Yes".

 

[Eric Blitzer]

I meant the report not form

Hi Eric,
Not sure if that will work - The report is from a table that is already
filled in & should not be changed, just want to not show the machines when
blank

Thanks Bert

 

[Eric Blitzer]

Another method is to put some code in the on format event of that section of
the report

if isnull(me.[machine] then
me.[machine].visible = false
else
me.machine.visible=true
end if

 

[Bert]

Hi Eric,
Thanks for your help but when I look at the properties on the control in the
report - the event tab is blank (I will try this code in a form as it may be
useful)
Maybe I did not explain fully where the report comes from: It is a table
with the person name with fields for machine type , this machine type field
is a lookup to another table containing the machine types. So it appears in
the report as a control with a drop down arrow at the side & blank on the
data tab

Thanks
Bert

Another method is to put some code in the on format event of that section of
the report

if isnull(me.[machine] then
me.[machine].visible = false
else
me.machine.visible=true
end if

Hi Eric,
Not sure if that will work - The report is from a table that is already
filled in & should not be changed, just want to not show the machines when
blank

Thanks Bert