Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Select Case Me.SubCategory.Value
Case "Soft Drinks"
Me.SubCategory.FontBold = True
Me.SubCategory.FontSize = 12
Me.SubCategory.FontName = "Verdana"
Case "Chemical"
Me.SubCategory.ForeColor = vbBlue
Me.SubCategory.FontSize = 10
Me.SubCategory.FontName = "Arial"
Case "General"
Me.SubCategory.ForeColor = vbRed
Me.SubCategory.FontSize = 11
Me.SubCategory.FontName = "Times New Roman"
Case "Tea / Coffee"
Me.SubCategory.ForeColor = vbGreen
Me.SubCategory.FontSize = 8
Case Else
Me.SubCategory.ForeColor = vbBlack
Me.SubCategory.FontSize = 9
Me.SubCategory.FontName = "Verdana"
End Select
End Sub