Check Box - Formatting action 2

[filthepitome]

First I would like to say I know zero VB, I could work my way through editing some of it, but could not write it myself.

That being said does anyone know of an "easy" way to keep say 3 fields hidden. If a check box is clicked (Value to Yes) the three hidden fields will become visible and data can be entered into them.

Sorry for the generic dumb question, but if anyone can be of any help it would be greatly appreciated

TIA

 

[TheAceMan1]

how are ya filthepitome . . .

In the [blue]AfterUpdate[/blue] event of the checkbox try this:

[blue]   Dim flg As Boolean
   
   If Me!CheckboxName Then
      flg = True
   Else
      flg = False
   End If
   
   Me![purple][b][i]textbox1Name[/i][/b][/purple].Visible = flg
   Me![purple][b][i]textbox2ame[/i][/b][/purple].Visible = flg
   Me![purple][b][i]textbox3ame[/i][/b][/purple].Visible = flg[/blue]

See Ya! . . . . . .

 

[TheAceMan1]

Sorry about the mess . . .

Should be:

[blue]   Dim flg As Boolean
   
   If Me![purple][b][i]CheckboxName[/i][/b][/purple] Then
      flg = True
   Else
      flg = False
   End If
   
   Me![purple][b][i]Textbox1Name[/i][/b][/purple].Visible = flg
   Me![purple][b][i]Textbox2Name[/i][/b][/purple].Visible = flg
   Me![purple][b][i]Textbox3Name[/i][/b][/purple].Visible = flg[/blue]

See Ya! . . . . . .

 

[filthepitome]

AWESOME !!!!!!!!!!!!! Works flawlessly, thank you very very much

 

[TheAceMan1]

filthepitome . . .

[/blue]Great![/blue]

BTW: [blue]Welcome to Tek-Tips![/blue] To get great answers be sure to have a look at FAQ219-2884 or FAQ181-2886

See Ya! . . . . . .

 

[Pampers]

Hi filthepitome,
If someone successfully answered your question, please give him/her a star, not only to credit the person, but so other people can see that the issue is dealt with.

Pampers
Keeping it simple can be complicated

 

[TheAceMan1]

Howdy pampers . . .

Appreciate the post and intent . . . but prompting for stars is inapproriate in the forums . . . however leaving the faq's is

See Ya! . . . . . .

 

[Pampers]

Hi TheAceman1,
Yes I know... Couldn't resist. ;-)


Pampers
Keeping it simple can be complicated

 

[TheAceMan1]

pampers

See Ya! . . . . . .