Ckbox Q:

M

Mike

Hi,
When a checkbox is marked in a form, a -1 is stored in a SQL table where the
field is an int.
How can I store an 1 instead of a -1?
TIA
Mike
 
G

Graham R Seach

Mike,

Change the SQL column to a BIT datatype.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to automate update on weekly reports spreadsheet 0
Looking for a shortcut 0
Sub projects added as read only in Master file which are saved on sharepoint 1
capture date at another sheets using Marlett 1
Sorting and filtering text 0
Making a macro only work on certain files 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Automatic indexing in footnotes - solved 0

Top