Triplestate

[Pete Cumberland]

HI,
Iv'e recently upgraded from Access 97 to 2003 and all of my
TripleState
checkboxes are now only double state, ie: I can only get tick or blank but
not greyed out. I've searched for help on this but can only find info
relating to VBA coding which I know nothing about. I know that I didn't
have to use VBA for the 97 version. So what do I do?

thanks

Pete



I'm protected by SpamBrave
http://www.spambrave.com/

 

[Guest]

Hi Pete

I had the same problem a few years ago. (when 1st going to 2k3)

2003 check boxes either Are (=-1 / checked) or Ain't (=0 / not checked).
Very strange.

The simple way round this is to disable the check box in certain
circustances. Something like (or any of loads of other events) this on form
open. There are prob other ways around this but as this works for me (and
it's so simple) I didn't look into it too much.


Private Sub Form_Open(Cancel As Integer)
If Me![SomeField].Value = SomeNumber Then
Me![CheckBox].Enabled = False
End Sub

Or

Private Sub Form_Open(Cancel As Integer)
If Me![SomeField].Value = "SomeText" Then
Me![CheckBox].Enabled = False
End Sub

Of course you can use "Else" to enable if you want - but shouldn't be
nessessary if SomeField does = ?? and you refresh.

Hope this helps

 

[Ken Snell \(MVP\)]

To get a triplestate checkbox on a form to be used for storing data entry,
change the Yes/No field in the table to an Integer field. Then you can
continue using the TripleState checkbox on the form for that field.

 

[Guest]

To add some to what Ken has said, I *think* you can achieve the former effect
by not using Themed Controls in Access 2003. Look for an option to use Themed
Controls under Tools > Options.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Pete Cumberland]

Sorry I thought I'd replied to this message but it's not appeared yet so
am
sending again.

Hi Ken,
many thanks for your reply. What do you mean by an "Integer" field?
I've looked and can't find anything to select so assume that "Integer" is
a
more general term.

Pete

To get a triplestate checkbox on a form to be used for storing data
entry, change the Yes/No field in the table to an Integer field. Then
you can continue using the TripleState checkbox on the form for that
field.

I'm protected by SpamBrave
http://www.spambrave.com/

 

[Pete Cumberland]

Hi Tom,
I've laready looked at this but it didn't apply.

Pete

To add some to what Ken has said, I *think* you can achieve the former
effect
by not using Themed Controls in Access 2003. Look for an option to use
Themed
Controls under Tools > Options.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

I'm protected by SpamBrave
http://www.spambrave.com/

 

[Douglas J. Steele]

Presumably the field in your table is currently labelled as a Yes/No field.
(Actually, it's a Boolean field, but Access uses the Yes/No label).

Change the Yes/No field to Numeric. Look at the Field Size property (on the
General tab in the bottom left-hand corner of the dialog), and you should
see that it's set to Long Integer. You could change that to Integer,
although Long Integer should work fine. (It's just that the field will now
take 4 bytes to store the value, as opposed to 2 bytes for Integer, or 1
byte for Yes/No)