default value for checkbox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am now trying to create a default value for a check box. If a customer is
new, a check must be entered to indicate YES. I also want a default value
showing that the customer is not new.

So under Field Properties, under Default Value, I put: =No
But I'm not sure this will give me the result I'm trying to get.

The Field Name is "New Customer" for the data type check box Y/N

Thanks in advance.
 
ditnog,
Default Value only gets applied on New records. So the default value for NewCistomer
would be True.
All previously created customer records will have to have thier NewCustomer set to
False by an Update query, or manual entry.

This really doesn't make sense though... what makes a Customer "new"? Just because
it's a new record?
Or... is there some other criteria that, when satisfied, makes a customer Not "new"?

If so, use that logic in your Update query.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
I am now trying to create a default value for a check box. If a customer is
new, a check must be entered to indicate YES. I also want a default value
showing that the customer is not new.

So under Field Properties, under Default Value, I put: =No
But I'm not sure this will give me the result I'm trying to get.

The Field Name is "New Customer" for the data type check box Y/N

Thanks in advance.
Click to expand...

No is stored as 0, Yes as -1. Try using these for the default.

Thre's nothing in what you say which indicates how you ascertain that a
customer is new, and it's not clear just what you mean by " If a customer is
new, a check must be entered to indicate YES. I also want a default value
showing that the customer is not new. " It sounds like you're saying that you
want the default value to be Yes, or maybe No, depending on whether it's a new
customer - how can Access (or your users!) tell if the customer is new or not?

John W. Vinson [MVP]
 
Back
Top