customizing yes/no data type

[Alesia]

I am new to Access 2003. I have a guide to building a database using MS
Access 2003 that said that I can customize the two variables when using the
yes/no data type for a field. I have tried using the codes given by the
Microsoft Access Help; however, even when I follow the model given, my
variables either do not show up at all or only one variable shows up but no
check boxes appear. Does anyone happen to know how to customize the
variables?

 

[Klatuu]

Don't know what you mean by customizing a varialbe type. The you say field.
A field and a variable are two totally different entities. A field is a
property of a table. In the table design, there are certain properties you
can set for a field, one of which it the type of data to be stored in the
field.

A variable is a named memory location intended to contain a value of a
specific or non-specific data type. A non-specific data type is a Variant.
A Variant variable will accept any data type. Otheres, such as String, Long
Integer, Boolean will accept only a compatible data type or a data type that
can be coersed into the correct data type. For example, a variable Dimmed as
a String variable will allow you to assign a date value to it:
strStingVariable = Date()
and it will internally convert the date value into a string value. But, a
string value cannot be coersed into a date format unless the string can be
seen as a date. For example,
dtmDateVarialbe = "Fizwa"
Will return an error 13 (Type Mismatch)
Bit
dtmDateVarialbe = "5/25/2007"
will convert the string to a date.

Now, that is a long explanation, but still doesn't answer your question.
To answer your question, I need to know What you are trying to accomplish.
With that, I can provide a How.

 

[Alesia]

Hello,

Thanks for the response. All I am trying to accomplish is to customize the
yes/no data type for a couple of fields. For example, instead of having
yes/no or true/false options in a field, I would like to change/customize the
data type so that I can have north/south check boxes.
Any help in doing this would be greatly appreciated!
Thanks!

Alesia

 

[Klatuu]

Where do you want to do this? On a form, a report, or what.
You can't do this in table design.
If what you want to have a North/South selection on a form, then I would
suggest rather than a Yes/No field type, you use a numeric long integer data
type bound to an option group with two toggle buttons each with its own
option value and label the buttons North and South.