Changes on continuous form affect all records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a form in continuous view. I want when user makes a selection
on a combo box a text box is made not visible. I do that with a macro but
because form is in continuous this happens in all records and not in the
edited one. Any help?
 
You may be able to achieve what you want by using conditional formatting.
Edit the form in Design view, use an expression to determine the conditional
formatting, for example:

[MyComboBox] = 2

Then set the foretext to the same color as the background if the condition
is met. The textbox will still display, but not the text within it.

Hope that helps.
Sprinks
 
Thank you, it solved my problem, but just from curiosity could i do this with
a macro?

Sprinks said:
You may be able to achieve what you want by using conditional formatting.
Edit the form in Design view, use an expression to determine the conditional
formatting, for example:

[MyComboBox] = 2

Then set the foretext to the same color as the background if the condition
is met. The textbox will still display, but not the text within it.

Hope that helps.
Sprinks



Βάππας Κωνσταντίνος said:
I have created a form in continuous view. I want when user makes a selection
on a combo box a text box is made not visible. I do that with a macro but
because form is in continuous this happens in all records and not in the
edited one. Any help?
Click to expand...
Click to expand...
 
As macros are extremely limited, I do not use them. But I don't believe it
is possible. If in VBA, for example, you set the ForeColor property equal to
the BackColor property:

If MyComboBox = MyValue Then
MyTextbox.ForeColor = MyTextbox.BackColor
Else
MyTextbox.ForeColor = 0
End If

it would apply to all records on the subform. That is why Microsoft
provided Conditional Formatting.

Sprinks

Βάππας Κωνσταντίνος said:
Thank you, it solved my problem, but just from curiosity could i do this with
a macro?

Sprinks said:
You may be able to achieve what you want by using conditional formatting.
Edit the form in Design view, use an expression to determine the conditional
formatting, for example:

[MyComboBox] = 2

Then set the foretext to the same color as the background if the condition
is met. The textbox will still display, but not the text within it.

Hope that helps.
Sprinks



Βάππας Κωνσταντίνος said:
I have created a form in continuous view. I want when user makes a selection
on a combo box a text box is made not visible. I do that with a macro but
because form is in continuous this happens in all records and not in the
edited one. Any help?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top