On Wed, 10 Jul 2002, Nigel J. Andrews waxed:
>
> On Tue, 9 Jul 2002, John L. Turner wrote:
>
> > By mistake, I named a Form's data box, starting with a Capital letter.
> > Received a message, but can not delete said offender.
> > I removed the control from the Form, but still I get an error when Form opens.
>
> I think you probably need to edit the formsource column in the pga_forms
> table. I haven't done this myself, or looked too closely at the contents of the
> table but I presume that your deletion of the form item hasn't been propagated
> into the description held for the form in the database and that therefore you
> need to make the deletion by hand.
>
> You should be able to do this within pgaccess if I'm not mistaken.
>
I never tried this before, so I named a couple of buttons and entry
boxes on a form with starting Capitals. Sure enough, after I saved, then
opened the form, it complained. But to fix it I didn't have to go into
the pga_forms table. I just designed the form again, changed the first
letter to lower case, and saved then opened it. Works like a champ.
If I didn't get that bug correctly reproduced, please file a report at
bugzilla.pgaccess.org, so we can address the problem in more depth and
off-list.
--Chris Maj
--
cmaj_at_freedomcorpse_dot_info
0xC0051F6A
5EB8 2035 F07B 3B09 5A31 7C09 196F 4126 C005 1F6A