How do I hide "empty" labels/text boxes in my forms

[Biologybook]

I am trying to create a form for use in a manufacturing process. The first couple columns in my table are filled with parameters and the last 5 columns are for steps in the process (i.e. Steps A-E). I want to make a unique form for each row.



Some processes only need 2-3 step though; so these cells are left blank. These "empty" fields still show up on my form.

Is there anyway to hide these?



Thanks for your help in advance!

[Robeen]

If you don't need them on your Form, you can choose not to put them on when you design the Form.

In Design mode - you can right-click on the field that you don't neet, Select 'Properties' and then set the 'Visible' property to 'No' [or False].

If you REALLY don't need certain fields [controls] to show on you Form - you can delete the controls [Right-Click -> Delete].

If you want the fields to show under certain conditions, you can write code that sets the Visible Property of a certain control to False.

[Biologybook]

Thanks for the quick response!

I need fields to show under certain conditions. The condition being if there is text in the box. If there is no step D and E for a process, I don't want it showing up on my form as a blank box.

Writing code? I am just learning Access and don't know what you're referring too.

[Robeen]

Are you using your Form to enter data or just to display it?

[Biologybook]

just display it for the machine operators.

[Robeen]

Here is a quick code snippet for you to play with.

I worked this up before you replied but you might be able to use it.

I put a command button on a simple form and called it Command9.
I also have text boxes called Step4 & Step5.

When I click the Command Button, if the 'Process' Text Box has "X" then Text Boxes 'Step4' & 'Step5' are turned to Visible = False.

 
Private Sub Command9_Click()
 
If Me!Process = "X" Then
Me!Step4.Visible = False
Me!Step5.Visible = False
 
End If

This is to give you an idea of how writing Code works.

Here's what you do if you want to replicate what I did.

Put a command button on your Form.
RIght-Click the command Button and click 'Build Event' and then select 'Code Builder'.
You should be taken to the Visual basic Editor and should see something like this:

Private Sub Command9_Click()

End Sub

Between those two lines is where you would enter the code to tell your application what you want to happen when you click the command button.

Your goal is to put this code where it will be run each time a new record is loaded into the Form.

All the best!!