Access - Continuous Form - Unbound Toggle
Posted on 2013-01-17
I am working with a Continuous Form. There is a Yes/No field in my table that is bound to the form but I hate how small the Checkbox visually is on my continuous form.
I know I can put a Toggle button on the form and set the Font to Wingdings 2 and if the toggle is checked change the Caption to "P" which will display a checkmark any size that I want. However, since it is an unbound Toggle then whatever the last visual toggle I clicked ALL of the toggle controls display the same thing even if that particular record is No.
Is there any way in vbcode I can get around this for a continuous form OR does is there any way to make MS's checkbox control for a Y/N field bigger???????
The code I have for making the toggle display a check or not is:
Private Sub Pull_OnClick()
Private Sub tglPull_Click()
If Me.LVLReportingMachPulledIndicator = True Then
Me.LVLReportingMachPulledIndicator = False
Me.tglPull.Caption = ""
Me.LVLReportingMachPulledIndicator = True
Me.tglPull.Caption = "P"