Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 318
  • Last Modified:

Change a filed from visible to invisible on a form

I am using a continuous form.  depending on a field in the same record I need to make the field invisible.   All the fields become invisible, not just the one that I selected.
ex: if Field1 = Completed then make Field2, which is STOP to invisible.
0
Startrac98
Asked:
Startrac98
  • 3
  • 2
1 Solution
 
mbizupCommented:
That's not going to work out on a continuous form... all records will either have the textbox visible or hidden.

You CAN however, use conditional formatting to enable/disable that field.

Under conditional formatting for the field you want to change:

-  Select Expression IS from the drop down.
- Enter the following expression in the space provided:
        [Field1] = "Completed"
- Choose disabled for your formatting for this criteria
0
 
mbizupCommented:
Alternatively, you can use conditional formatting to set the text and background colors of the field to match so that the field appears hidden under that condition and use code in your form's current event to prevent the user from editing it:

Private Sub Form_Current()
   Me.Field2.Locked = ([Field1] = "Completed")
End Sub

Open in new window

0
 
Dale FyeCommented:
In addition to mbizup's comment about locking the field in the Current Event, you could use the GotFocus event of the control to actually shift the focus to another control if [Field1] is completed.

If you use conditional formatting to simply change the foreground and background colors of the control, it can still get the focus, and if it gets the focus, the user can still see the value by highlighting all of the text in the control.  If, however, you use the GotFocus event to shift the focus to another control, they will not be able to do this.
Private Sub txt_Field2_GotFocus

    if [Field1] = "Completed" Then me.txt_Field2.Setfocus

End Sub

Open in new window

0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
mbizupCommented:
<<
it can still get the focus, and if it gets the focus, the user can still see the value by highlighting all of the text in the control
>>

Dale,

 I haven't tested this, but I think that locking/disabling the control through the current event would prevent this.
0
 
Dale FyeCommented:
Miriam,

Disabling (Yes), Locking (No), Changing Fore/Back Colors (No).

Actually, I have used the changing fore/background color technique in the past, because my client did not even want my users to see the "hidden" fields if certain conditions existed.  However, when I did this, I encountered the situation that even though the control was not "visible" (same color as the detail background), I could click into it and if I highlighted the text it was readable.

Yes, you could also lock it, but I simply preferred to shift the focus out of that control immediately upon it getting the focus.
0
 
Startrac98Author Commented:
Thank you.  Worked out perfect.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now