On a continuous form, I have some text box controls that are enabled or unenabled by conditional formatting, depending on the value of a Toggle control. The Toggle default is ‘False’, which should make the text boxes unenabled. On opening, I assumed that those text boxes would show as unenabled, but they don’t. If I click a the toggle, then all the records then show enabled/unenabled as they should. If I set the text box to unenbaled as default, then the Toggle does nothing when clicked – the text box remains unenabled.
A work around is to toggle the three Toggle controls twice on opening:
Code: Select all
NWOnOff = Nz(Me![tglNWReqd?])
IPOnOff = Nz(Me![tglIPReqd?])
InsOnOff = Nz(Me![tglInsReqd?])
Me![tglNWReqd?] = Not NWOnOff
Me![tglNWReqd?] = NWOnOff
Me![tglIPReqd?] = Not IPOnOff
Me![tglIPReqd?] = IPOnOff
Me![tglInsReqd?] = Not InsOnOff
Me![tglInsReqd?] = InsOnOff
This works. (sorry, can't find the 'Code' button)