Hiding and Showing Textbox

[Marryp]

How can I hide a textbox with no value without leaving a space for the next line ie

Record1
Tel: 9999999
Fax: 888888
Email: hello@yahoo.com
Website:

http://www.tek-tips.com

Record2
Tel: 22222222
Website:

http://www.tek-tips.com

Record3
Tel: 3333333

 

[Remou]

On a form or a report?

 

[Marryp]

On the report

 

[Remou]

Either set the textbox edges to match up (very carefully) and set Can Shrink to Yes, or use one text box and some code to concatenate lines.

 

[Marryp]

Concatenate will not work because I used bold formatting on the label. How do I match up the textbox. It will still leave a space.

 

[sin1965]

do you know how to code VBA?

 

[Marryp]

yeah but not too expert

 

[sin1965]

i'll get back to u tomorrow with some ideas. time for dinner!
steve

 

[ZmrAbdulla]

Try using conditional statement

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.Email = "" Then Cancel= True 
End Sub

________________________________________________________
Zameer Abdulla
Help to find Missing people
Do not cut down the tree that gives you shade.

 

[Remou]

You could try changing the labels to Textboxes and setting each control source:
=IIf(Trim() & ""<>"","Email","")
etc. Then set the Can Shrink property for all the textboxes (including the new textbox labels) and the Report Detail to Yes. Finally, line up the textboxes carefully, so that the bottom of each box coincides with the top on the box beneath, otherwise, when the label shrinks, you are left with too much space.