Hi Rod
Could you please post the code for your IsBitSet function? Also, what datatype is tmpFormAccess?
All the best,
Graham
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, 7 August 2014 15:51
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] having issue with checkbox
Trying to set the enabled and locked properties based on a test of a controls tabindex. This is being used to define user access.
ctlbit = ctl.TabIndex
ctl.Enabled = (IsBitSet(ctlbit, tmpFormAccess))
ctl.Locked = Not (IsBitSet(ctlbit, tmpFormAccess))
I test the bit of a number based on the tabindex of the control. I get an error of "Type Mismatch" The IsBitSet function returns TRUE or FALSE. The issue appears to be only associated with one control which is a checkbox ( two others appear to be working properly).
ctl is an control
Not sure what the issue is, am going to try deleting control and re-creating it. Any other ideas.
Using Access 2010 on Windows 7 and 8.1
Rod
Posted by: "Graham Mandeno" <graham@mandeno.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar