Moving Check Boxes!

[Guest]

I'm creating a simple form where the User will check the box if they want something done, and in the next row, they then type in the instruction. The instruction cell is set to wrap-text.

I'm finding if the text actually wraps, the check-box from the row underneath it moves up a row

How do I lock it down? (I've tried both "Move but don't size with cells" and "Don't move or size with cells" - neither seems to have any affect

Help
Thank you!

 

[Dave Peterson]

It sounds like you used checkboxes from the Forms toolbar.

The checkboxes from the Control Toolbox toolbar have another option
Under right click|Format control, Properties tab

"move and size with cells"

I turned that on and did some light testing.

It seemed to work best if I placed the checkbox in the cell when the rowheight
was as small as it was going to be.

You can change the Font size of the checkbox by rightclicking on it and choosing
Properties and then Font.

(You'll have to be in design mode--the topleft icon of the Control toolbox
toolbar).

But try it a little before you convert them all. It didn't look very pretty to
me--but it did work.

 

[Dave Peterson]

Another technique to keep a minimum rowheight is to use a dummy column with text
that doesn't allow autofit to make it too small. (just some dummy text will
do).

Hide the column and the rowheight will still respect what's in that cell.

 

[Guest]

Dave - Just wanted to thank you for your assistance. I've tried that Control Toolbox before - but didn't realize the secret to it was the "Design Mode" button! Besides solving my problem, you've opened up a whole new world for me! Thanks!