Non existant control source on a form

[goldenvision]

Is it possible to use the visible function to show or hide a none existant control source on a form?

 

[bat17]

You have lost me! if it does not exist how can you show it?

Can you give a bit more detail of what is happening and what you are trying to achieve?

Peter

 

[goldenvision]

There is a form bound to a crosstab table which will eventually contain 60 fields. It currently contains around 10 the other 50 fields are bound to the control sources that will exist in the future but not at the moment (still with me)
They currently display #Name. I want to hide them so only the text boxes with a valid value are displayed

 

[bat17]

the only thing that I can think of is to trap the error when you try to read the value. try this code in the Current event of the form. it will probably be possible to add a loop so you dont have to name all 50 fields individualy

Dim xxx As Variable
Dim bolShow As Boolean

bolShow = True
On Error GoTo errorTrap

   xxx = Me.Text20
   Me.Text20.Visible = bolShow
   bolShow = True

Exit Sub

errorTrap:

If Err.number = 2424 Then
   bolShow = False
   Resume Next
End If

Peter