What is 'Fetch Defaults' for?

[Jeff]

Out of curiosity, I tried to check the help file for the property 'Fetch
Defaults' to see what it is for. No surprise, it is not mentioned. F1 on the
property give nothing. A search of MS knowledge base is equally unhelpful.

Can anyone explain what this new property in 2003 is for?

Jeff

[WindAndWaves]

it will find the defaults when you open a form. If the defaults for a
control are rather complex then it may pay to set this to false and I can
think of some other reasons too.

"Jeff" <je************@asken.com.au> wrote in message
news:ld*******************@news.optus.net.au...

Out of curiosity, I tried to check the help file for the property 'Fetch
Defaults' to see what it is for. No surprise, it is not mentioned. F1 on the property give nothing. A search of MS knowledge base is equally unhelpful.

Can anyone explain what this new property in 2003 is for?

Jeff

---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.688 / Virus Database: 449 - Release Date: 18/05/2004

[Jeff]

What defaults? The default settings for a control? Wouldn't that mean that
any settings made, such as colors etc would be lost if it reset everything
on the form to default settings? Why would you use this?

And why isn't such as basic property in the help file?

A lot of questions but I am interested in why such a powerful property is
not documented?

Jeff

"WindAndWaves" <ac****@ngaru.com> wrote in message
news:xO*******************@news.xtra.co.nz...

it will find the defaults when you open a form. If the defaults for a
control are rather complex then it may pay to set this to false and I can
think of some other reasons too.

"Jeff" <je************@asken.com.au> wrote in message
news:ld*******************@news.optus.net.au...

Out of curiosity, I tried to check the help file for the property 'Fetch
Defaults' to see what it is for. No surprise, it is not mentioned. F1 on the

property give nothing. A search of MS knowledge base is equally unhelpful.
Can anyone explain what this new property in 2003 is for?

Jeff

---
Please immediately let us know (by phone or return email) if (a) this

email contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.688 / Virus Database: 449 - Release Date: 18/05/2004

[Joan Wild]

I believe (could be wrong) that it is used to get the properties for a bound
field and apply them to the control.

I suppose, if you changed a field's properties after creating a form, you
could use this to update the control?

--
Joan Wild
Microsoft Access MVP

"Jeff" <je************@asken.com.au> wrote in message
news:lz*******************@news.optus.net.au...

What defaults? The default settings for a control? Wouldn't that mean that
any settings made, such as colors etc would be lost if it reset everything
on the form to default settings? Why would you use this?

And why isn't such as basic property in the help file?

A lot of questions but I am interested in why such a powerful property is
not documented?

Jeff

"WindAndWaves" <ac****@ngaru.com> wrote in message
news:xO*******************@news.xtra.co.nz...

it will find the defaults when you open a form. If the defaults for a
control are rather complex then it may pay to set this to false and I can

think of some other reasons too.

"Jeff" <je************@asken.com.au> wrote in message
news:ld*******************@news.optus.net.au...

Out of curiosity, I tried to check the help file for the property 'Fetch Defaults' to see what it is for. No surprise, it is not mentioned. F1

on the

property give nothing. A search of MS knowledge base is equally

unhelpful.
Can anyone explain what this new property in 2003 is for?

Jeff

---
Please immediately let us know (by phone or return email) if (a) this

email

contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.688 / Virus Database: 449 - Release Date: 18/05/2004

[Wayne Morgan]

From the help file:
Returns or sets a Boolean indicating whether Microsoft Access shows default
values for new rows on the specified form before the row is saved. True if
Access shows the default values for new rows on the specified form.
Read/write.

I believe this means that when you go to a new record, the default values
for the fields (if any) will be shown, otherwise they are applied when the
field is saved if you've left the field blank.

--
Wayne Morgan
Microsoft Access MVP
"Joan Wild" <jw***@nospamtyenet.com> wrote in message
news:10*************@corp.supernews.com...

I believe (could be wrong) that it is used to get the properties for a bound field and apply them to the control.

I suppose, if you changed a field's properties after creating a form, you
could use this to update the control?

--
Joan Wild
Microsoft Access MVP

"Jeff" <je************@asken.com.au> wrote in message
news:lz*******************@news.optus.net.au...

What defaults? The default settings for a control? Wouldn't that mean that

any settings made, such as colors etc would be lost if it reset everything on the form to default settings? Why would you use this?

And why isn't such as basic property in the help file?

A lot of questions but I am interested in why such a powerful property is not documented?

Jeff

"WindAndWaves" <ac****@ngaru.com> wrote in message
news:xO*******************@news.xtra.co.nz...

it will find the defaults when you open a form. If the defaults for a
control are rather complex then it may pay to set this to false and I

can think of some other reasons too.

"Jeff" <je************@asken.com.au> wrote in message
news:ld*******************@news.optus.net.au...
> Out of curiosity, I tried to check the help file for the property 'Fetch > Defaults' to see what it is for. No surprise, it is not mentioned.

F1 on the
> property give nothing. A search of MS knowledge base is equally

unhelpful.

>
> Can anyone explain what this new property in 2003 is for?
>
> Jeff
>
>
---
Please immediately let us know (by phone or return email) if (a) this

email

contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.688 / Virus Database: 449 - Release Date: 18/05/2004

[Joan Wild]

"Wayne Morgan" <co***************************@hotmail.com> wrote in message
news:nn*************@newssvr19.news.prodigy.com...

From the help file:
Returns or sets a Boolean indicating whether Microsoft Access shows default values for new rows on the specified form before the row is saved. True if
Access shows the default values for new rows on the specified form.
Read/write.

I believe this means that when you go to a new record, the default values
for the fields (if any) will be shown, otherwise they are applied when the
field is saved if you've left the field blank.

Thanks Wayne, that makes more sense. Jeff said he couldn't find it in help
--
Joan Wild
Microsoft Access MVP

[Jeff]

Thanks everyone.

After Wayne's comment I went back to the help file. Nothing comes up looking
for FetchDefaults, but if you lookup the form object and then it's
properties (don't ask me why I didn't try this slant before) you will get
some help, though a little vague.

Jeff

"Joan Wild" <jw***@nospamtyenet.com> wrote in message
news:10*************@corp.supernews.com...

"Wayne Morgan" <co***************************@hotmail.com> wrote in message news:nn*************@newssvr19.news.prodigy.com...

From the help file:
Returns or sets a Boolean indicating whether Microsoft Access shows default

values for new rows on the specified form before the row is saved. True if Access shows the default values for new rows on the specified form.
Read/write.

I believe this means that when you go to a new record, the default values for the fields (if any) will be shown, otherwise they are applied when the field is saved if you've left the field blank.

Thanks Wayne, that makes more sense. Jeff said he couldn't find it in

help

--
Joan Wild
Microsoft Access MVP

[Wayne Morgan]

Hi Jeff,

It's in the VBA help. If you open the VBA window and then search on
FetchDefaults (no space between the words) it should show up.

--
Wayne Morgan
Microsoft Access MVP
"Jeff" <je************@asken.com.au> wrote in message
news:b%*******************@news.optus.net.au...

Thanks everyone.

After Wayne's comment I went back to the help file. Nothing comes up looking for FetchDefaults, but if you lookup the form object and then it's
properties (don't ask me why I didn't try this slant before) you will get
some help, though a little vague.