Set Visible to No, then resize adjacent field

[tjcinnamon]

I have and Owner name and a tenant name in a report. Is there a way where if the tenant name is empty, I can rezise the owner field to encompass where the tenant field would have occupied, if it was not null? I can make a macro to make the tenant field invisible, but I do not know how to resize the owner field.

Any thoughts appreciated,
JOe K.

 

[llkhoutx]

Set the fields width and height properties appropriately. Note that those values are in rasters, 1440ths of an inch. For 1 inch put 1440.

I advise that you start using VBA instad of macros. You'll find that VBA is much easier.