Re: Fields in a form?

Have you looked at the help files?  They spell it all out.

The maximum is 255 over the lifetime of the form.  That means that adding a 
control, then later deleting it still counts.  Compacting your database will 
help with this issue.

To get around this, you can use subforms.  Each subform can have 255 
controls as well.

-- 
Rick B



"JPS" <JPS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message 
news:471F7B5E-7E28-48BC-B6F0-6EBFEC3F5C1F@xxxxxxxxxxxxxxxx
> What is the maximum number of fields that can be added to a form. I have
> several tables which I need to show on one form but an error message tells 
> me
> that I have too many fields defined.
> Would sub-forms help and if so, how do i do them.
> Thanks 


.

Relevant Pages

  • Re: Subforms
    ... A subform is just another control that you can place on a form. ... *lifetime* of the form, you can only ever place 754 controls on a form. ... limit, you can overcome it by exporting the form to a text file, then ... > What is the limit on the number of subforms that you can have in a form? ...
    (microsoft.public.access.forms)
  • Re: Using Checkboxes in Subforms
    ... I continue to get an error message however - I don't ... some data I found on how to refer to parent & subforms I think it should read ... > similar control on the parent form. ... > would cause the selected record to immediately disappear. ...
    (microsoft.public.access.forms)
  • Re: NTSVC.OCX Help needed
    ... "When you use the Services snap-in to start a local service on a Microsoft ... The "cause" is stated as "This arbitrary time limit had been set with the ... error message and continue to check for the service to start. ... you must check the System event log for Service Control ...
    (microsoft.public.vb.general.discussion)
  • Reuse error handling routines with Form.Dirty = False
    ... In my unbound form I have a tabbed control with bound subforms in it. ... "Switch database" form opens, user selects database ... Another issue that arises with the above approach is the edits in the active ...
    (microsoft.public.access.modulesdaovba)
  • Microphone wont work
    ... Control Panel/Sounds and Audio Device/Voice/Testing sound Hardware. ... Windows error message "Windows cannot execute DpvSetup.exe, ... Sounds And Audio Devices icon (in the Sounds, Speech, And Audio Devices ... Now it's time to edit the Registry. ...
    (microsoft.public.windowsxp.hardware)