Check Box

How do I default a Check Box to have the tick already in it
burnspaul [ Di, 22 Januar 2008 18:34 ] [ ID #1913845 ]

Re: Check Box

On Jan 22, 12:34=A0pm, Paul <burnsp... [at] hotmail.co.uk> wrote:
> How do I default a Check Box to have the tick already in it

set the default value to true i believe
frogsteaks [ Di, 22 Januar 2008 18:35 ] [ ID #1913846 ]

Re: Check Box

On 22 Jan, 17:35, frogste... [at] yahoo.com wrote:
> On Jan 22, 12:34=A0pm, Paul <burnsp... [at] hotmail.co.uk> wrote:
>
> > How do I default a Check Box to have the tick already in it
>
> set the default value to true i believe

Have set Default Value to True but no joy. Thanks
burnspaul [ Di, 22 Januar 2008 18:39 ] [ ID #1913848 ]

Re: Check Box

On Jan 22, 12:39=A0pm, Paul <burnsp... [at] hotmail.co.uk> wrote:
> On 22 Jan, 17:35, frogste... [at] yahoo.com wrote:
>
> > On Jan 22, 12:34=A0pm, Paul <burnsp... [at] hotmail.co.uk> wrote:
>
> > > How do I default a Check Box to have the tick already in it
>
> > set the default value to true i believe
>
> Have set Default Value to True but no joy. Thanks

If you have this on a form and the Check Box is bound to a field in
the underlying recordsource, then the box will reflect the value in
the current record. If it is an unbound object, then setting the
defualt to True will have it checked by default. If you are
attempting to set the default value of the check box for a new record
in the datasource, this is accomplished by setting the default for the
field in the table in question to True.
frogsteaks [ Di, 22 Januar 2008 20:01 ] [ ID #1913853 ]

Re: Check Box

There are 2 places where you would set the default value of a check box.

1) This is set in your Table
2) Secondly, in the Form where your table data is presented.

The Form will normally over-ride the Table's default.

To set the default value to show a tick you can use True, Yes or -1.

Changing the default value will only effect new data being entered. You
will need to edit any data that you may have at the time.


Hope this helps.


Dominic


"Paul" <burnspaul [at] hotmail.co.uk> wrote in message
news:62447773-032b-4f56-8230-fb1423f3a871 [at] i29g2000prf.google groups.com...
> How do I default a Check Box to have the tick already in it
Dominic Vella [ Mi, 23 Januar 2008 08:12 ] [ ID #1914579 ]
Datenbanken » comp.databases.ms-access » Check Box

Vorheriges Thema: Query not returning DB value...
Nächstes Thema: HOW TO MAKE CONNECTION ON SQL SERVER USING MS ACCESS AS A PLATFORM