Re: pgaccess form design

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