Re: Visible/Invisible textboxes on a form - done by record

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Pele,

This is not code related. In Design view of the form, select one of the textboxes you want this "invisible" to apply to, then go to the Format menu and select Conditional Formatting. Then you set it up like this (for example)... Enter 'Expression Is..." and then in the Condition box, I think it would be...
[Labor Rate Code]=2 Or [Labor Rate Code]=7
.... and then just set the background color and font color from the color tools.

--
Steve Schapel, Microsoft Access MVP


Pele wrote: 
Steve,

Thanks for the advice...Your suggestion will work quite fine.

Can you help me with the code, I am not savvy in VB. Thanks.

.

Relevant Pages

  • RE: Replace conditional formatting to use 4 conditions
    ... I see your design as being problematic, not to mention that you are going to ... end up with a christmas tree effect with all of that conditional formatting. ... Try taking the raw data that you have and placing it in a pivot table. ... Drag the months and names to the right column. ...
    (microsoft.public.excel.programming)
  • Re: Drop down list box colour
    ... in the design view of the form: ... Access Basics ... Billiam wrote: ... As to the conditional formatting, I do not know how to proceed--here is my best guess (you can LOL if you like!: ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Strange Background
    ... It might have to do with conditional formatting and the condition is changed ... It also has a horizontal border line that does the same. ... With the original design in place, prior to the cut and paste task, I ... the color bars and border. ...
    (microsoft.public.excel.programming)
  • RE: Conditional Formatting on non-numerical value
    ... Try the following in the Northwind.mdb sample database: ... To implement Conditional Formatting on text values: ... Open the Categories form in design view. ... administrators are stored in a separate table on a one-to-many relationship). ...
    (microsoft.public.access.forms)
  • RE: Conditional Formatting
    ... ' Not sure of exact format of the sub declaration - create it using the ... then all the textboxes in the main and subforms are green. ... formatting won't change the color for the textboxes on the subform until I ... Here is the expression in the conditional formatting on the textboxes of the ...
    (microsoft.public.access.forms)