Logical Field ?

  • Thread starter Thread starter Mike J
  • Start date Start date
M

Mike J

In VBA I am trying to set a YES/NO fiel to Yes or true.

rstMyTable!Field = True doesn't work.

How do I set it to true?

Mike
 
I assume "Field" means the Field Name of the Field you want to set the value
for the current Record of the Recordset.

* Have you checked and make sure the Recordset is updateable?

* Do you have rstMyTable.Update after the posted statement?
 
It will probably work, since any numeric value other than 0 is usually
interpreted as True in Boolean assignments, but vbYes is actually one
of the defined (Integer) vbMsgBoxResult return values, not a Boolean
value.

As others have implied, the OP's syntax is correct, but there may be a
missing .Update statement.
 
You must log in or register to reply here.

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

Insert multiple .dat files into one pdf without losing color of their graphs 0
"." versus "!" 2
Change Form Background Color 2
Validate the number of checkboxes that can be true 0
Running Query in VBA 2
Access VBA - Loop through table fields -> update Listbox 1
Field contents as variable 12
RE: Can a boolean ever be set to null? 0

Back
Top