Noticed Form Controls not updating

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
 
B

Bob Phillips

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)
 
D

Doug Bell

Hmmm, Thanks Bob, now I am puzzled.
I will have to start to think about reloading.
 
R

Rob van Gelder

Works for me...

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

Robin Hammond

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top