Help | Site Map
Connecting Tech Pros Worldwide
 
 
LinkBack Thread Tools
  #1  
Old December 12th, 2006, 01:05 AM
Stan
Guest
 
Posts: n/a
Default Form update on Table property change ?

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

  #2  
Old December 12th, 2006, 03:15 AM
Tom van Stiphout
Guest
 
Posts: n/a
Default 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
  #3  
Old December 12th, 2006, 12:05 PM
RoyVidar
Guest
 
Posts: n/a
Default 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


  #4  
Old December 12th, 2006, 10:05 PM
Bob Quintal
Guest
 
Posts: n/a
Default 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

  #5  
Old December 13th, 2006, 02:15 AM
Stan
Guest
 
Posts: n/a
Default 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
 

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over network members.
Post your question now . . .
It's fast and it's free

Popular Articles