Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
setting field type or definition to binary
1 view
Skip to first unread message
Sandy
Jan 8, 2007, 3:24:01 PM1/8/07
to
How do you set a field type to binary?
thanks
sandy
Klatuu
Jan 8, 2007, 3:43:01 PM1/8/07
to
There is no binary data type for fields in an Access table.
If you mean a field that will return only either True (-1) or False (0),
then you want a Boolean (Yes/No) field.
--
Dave Hargis, Microsoft Access MVP
If you mean a field that will return only either True (-1) or False (0),
then you want a Boolean (Yes/No) field.
--
Dave Hargis, Microsoft Access MVP
Van T. Dinh
Jan 9, 2007, 1:24:07 AM1/9/07
to
If I take into account of your earlier posts, I think you want a Text Field.
You will need to set the Validation Rule to allow only "0" and "1"
characters. You should also set the max length of 32 characters since the
Hex() function can handle numbers up to 8 Hex dgits.
--
HTH
Van T. Dinh
MVP (Access)
"Sandy" <Sa...@discussions.microsoft.com> wrote in message
news:6CA05171-2560-4514...@microsoft.com...
onedaywhen
Jan 10, 2007, 4:19:11 AM1/10/07
to
On Jan 8, 8:43 pm, Klatuu <Kla...@discussions.microsoft.com> wrote:
> There is nobinarydata type for fields in an Access table.
Jet certainly has a BINARY data type. See:
http://msdn2.microsoft.com/en-us/library/aa140015(office.10).aspx
Intermediate Microsoft Jet SQL for Access 2000 (February 2000)
The BINARY data type.
Jamie.
--
0 new messages