Noticed Form Controls not updating

  • Thread starter Thread starter Doug Bell
  • Start date Start date
D

Doug Bell

Hi,

I have noticed with Word & Excel that if you change the name of a control on
a form, the new control with its events do not (always) appear in the Code
selection combo boxes.

If I export the form and re-import it then the events are there ready to
use.
eg on existing form frmForm1. create a new Text Box, it will be called by
default "TextBox1", rename it to txtTextBox1, click view code and try to
select txtTextBox1 to select its AfterUpdate Event, txtTextBox1 is not in
the list but TextBox1 is. Remove and Export frmForm1 and then re-import it
and there is txtTextBox1 and its associated Events.

Is this a normal bug with Forms in Office 2000 or is it specific to my
install, I have never seen anything similar in Access or VB?

Just wondering, Doug
 
Hi Doug,

I have Office 2000 with XP and this behaviour does not show on my machine.
txtTextBox1 shows immediately.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Works for me...

Do you get the same result with a new Workbook, new UserForm etc...?
 
Doug,

I get this problem periodically in XP. Code Cleaner from Rob Bovey helps
automate the process of getting things working again.

It only appears on complex forms with a lot of controls when I add a new
control. I haven't noticed it renaming, but it is probably the same issue.

ie. you are not alone!

Robin Hammond
www.enhanceddatasystems.com
 
Back
Top