Access reports - having null fields not show 1

[KIDA1973]

Hello, I am still fairly new to Access, and would like some assistance with two seperate issues:

1) I have a report that has memo fields that I want to shrink and grow with respect to the content size of the memo field. I have set Can Shrink and Can Grow both to yes in properties, and it works great except for when I have a null field, then it displays the original box size that I set on the report with nothing in it (it doesn't shrink the box at all) However, if there is even one letter entered it will shrink the box.

2) I have lost my toolbox. When I re-entered a form that I had previously worked on, I cannot get my toolbox back. I am imagining that either you cannot add buttons, boxes, etc once you have used a form, or I am missing something. I hope for the latter. I have tried "View...Toolbox..." in the menus, but the Toolbox is greyed out.

Thanks in advance!
KID A 1973 in Boise Idaho

 

[MIKElaw]

On your first point

Use the OnFormat Event for the Detail section

If IsNull(Myfield) then
MyField.visible = False
else
Myfield.visible = True
end if

The myfield should be the textbox name not the contents

 

[KIDA1973]

Thanks MIKElaw! That worked perfectly. As far as the second problem, I figured it out myself - the problem was in the Tools...Startup choices. Thanks for the reply!

Cheers,
Matthew

Matthew Janes

Everything in its right place...