Connecting Tech Pros Worldwide Help | Site Map

Form update on Table property change ?

Stan
Guest
 
Posts: n/a
#1: Dec 12 '06
I am working with MS Office Access 2003 11.5614 on a computer running
XP. If I change a property such as the input mask in a table, to have
the change reflected in an existing form I have to go to the form
design, delete the field and re-insert it into the form to exhibit the
change in the property. Is there a command I can use to cause the
forms to refresh their conditions from the table ?

Thank you for your reply,

Stan Hanna

Tom van Stiphout
Guest
 
Posts: n/a
#2: Dec 12 '06

re: Form update on Table property change ?


On 11 Dec 2006 17:31:06 -0800, "Stan" <stanhanna@hotmail.comwrote:

That's by design. Therefore spend enough time on your table design
BEFORE you create your forms.

-Tom.


Quote:
>I am working with MS Office Access 2003 11.5614 on a computer running
>XP. If I change a property such as the input mask in a table, to have
>the change reflected in an existing form I have to go to the form
>design, delete the field and re-insert it into the form to exhibit the
>change in the property. Is there a command I can use to cause the
>forms to refresh their conditions from the table ?
>
>Thank you for your reply,
>
>Stan Hanna
RoyVidar
Guest
 
Posts: n/a
#3: Dec 12 '06

re: Form update on Table property change ?


"Stan" <stanhanna@hotmail.comwrote in message
<1165887066.485901.19060@79g2000cws.googlegroups.c om>:
Quote:
I am working with MS Office Access 2003 11.5614 on a computer
running XP. If I change a property such as the input mask in a
table, to have the change reflected in an existing form I have to go
to the form design, delete the field and re-insert it into the form
to exhibit the change in the property. Is there a command I can use
to cause the forms to refresh their conditions from the table ?
>
Thank you for your reply,
>
Stan Hanna
When you change properties in the 2003 version, you should get a
smart flag you can click (some thingie with a "lightening" on it),
where you are asked whether you want to propagate the changes
everywhere the field is used. Whether it works or not, I wouldn't
know.

--
Roy-Vidar


Bob Quintal
Guest
 
Posts: n/a
#4: Dec 12 '06

re: Form update on Table property change ?


RoyVidar <roy_vidarNOSPAM@yahoo.nowrote in
news:mn.63277d6c1adf0a2b.59509@yahoo.no:
Quote:
"Stan" <stanhanna@hotmail.comwrote in message
<1165887066.485901.19060@79g2000cws.googlegroups.c om>:
Quote:
>I am working with MS Office Access 2003 11.5614 on a
>computer running XP. If I change a property such as the
>input mask in a table, to have the change reflected in an
>existing form I have to go to the form design, delete the
>field and re-insert it into the form to exhibit the change in
>the property. Is there a command I can use to cause the
>forms to refresh their conditions from the table ?
>>
>Thank you for your reply,
>>
>Stan Hanna
>
When you change properties in the 2003 version, you should get
a smart flag you can click (some thingie with a "lightening"
on it), where you are asked whether you want to propagate the
changes everywhere the field is used. Whether it works or not,
I wouldn't know.
>
It's not called AutoCorrupt(tm) for nothing.


--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Stan
Guest
 
Posts: n/a
#5: Dec 13 '06

re: Form update on Table property change ?


Thanks Roy. I tried your thingie and it worked great.
Stan Hanna

RoyVidar wrote:
Quote:
"Stan" <stanhanna@hotmail.comwrote in message
<1165887066.485901.19060@79g2000cws.googlegroups.c om>:
Quote:
I am working with MS Office Access 2003 11.5614 on a computer
running XP. If I change a property such as the input mask in a
table, to have the change reflected in an existing form I have to go
to the form design, delete the field and re-insert it into the form
to exhibit the change in the property. Is there a command I can use
to cause the forms to refresh their conditions from the table ?

Thank you for your reply,

Stan Hanna
>
When you change properties in the 2003 version, you should get a
smart flag you can click (some thingie with a "lightening" on it),
where you are asked whether you want to propagate the changes
everywhere the field is used. Whether it works or not, I wouldn't
know.
>
--
Roy-Vidar
Closed Thread