Visual Basic&database, if/then statements and conditional formatting

if/then statements and conditional formatting

Author	Message
J.Obla #1 / 2	if/then statements and conditional formatting Hello I am hoping to get information on how to create if/then statements. We create a annual directory of services and have many yes/no questions (check boxes) we want to be able to only show those services that the program indicated it provides (only bosex that are checked). I also need information on how to do conditional formating for a report based on the above, how do i plan a layout when spacing may be less or more per organization based on their selection of services?? Any guides or online sites would be helpful!. J.Oblak
Sun, 06 Mar 2005 01:19:16 GMT

Harry Strybo #2 / 2	if/then statements and conditional formatting Quote: > Hello > I am hoping to get information on how to create if/then statements. We > create a annual directory of services and have many yes/no questions (check > boxes) we want to be able to only show those services that the program > indicated it provides (only bosex that are checked). > I also need information on how to do conditional formating for a report > based on the above, how do i plan a layout when spacing may be less or more > per organization based on their selection of services?? Any guides or online > sites would be helpful!. > J.Oblak Use an array of checkboxes. Dim n as Integer For n = MyChechBox.LBound To MyCheckBox.Ubound If (MyCheckBox(n).Value = VbChecked) Then 'Add the item (you could use the CheckBox Tag property to store a pointer of some sort) End If Next
Sun, 06 Mar 2005 04:48:14 GMT

Page 1 of 1

[ 2 post ]