ACCESS 2007 Forms; Formatting Question

Leftyrad · 11-04-2009, 06:37 PM

Hey Good People!

I am in the midst of creating a dbase for my organization. Our use of Access is a bit unusual and requires A LOT of fields/columns that Access is typically used for (I imagine).

Basically, I have several tables that have close to the max number of fields (one that actually needs more than 255! Could use some help here too to increase this number) and I am unable to create a form that fits all the fields.

Basically, my org trains people and we are using access to track a number of things for a 9 month training program. BC the number of records is limited to a set of folks, I really need more fields/categories to track and record each person rather than a set number of fields with a large number of records.

Is there a way I can remove the limitations in formatting for forms? I need the height & width of the form to be determined by me and unlimited rather than by access and perhaps default settings.

Any help would really, really be appreciated!

thanks in advance folks!

**2xgrump** · 11-05-2009, 12:32 AM

Hi leftyrad,

If you have several Tables you may link them by using Relationships and then you may choose whatever fields you need compiled in your Forms.

11-04-2009, 06:37 PM	#1 (permalink)
Leftyrad Registered User Join Date: Oct 2008 Posts: 4 OS: Vista Ultimate	ACCESS 2007 Forms; Formatting Question Hey Good People! I am in the midst of creating a dbase for my organization. Our use of Access is a bit unusual and requires A LOT of fields/columns that Access is typically used for (I imagine). Basically, I have several tables that have close to the max number of fields (one that actually needs more than 255! Could use some help here too to increase this number) and I am unable to create a form that fits all the fields. Basically, my org trains people and we are using access to track a number of things for a 9 month training program. BC the number of records is limited to a set of folks, I really need more fields/categories to track and record each person rather than a set number of fields with a large number of records. Is there a way I can remove the limitations in formatting for forms? I need the height & width of the form to be determined by me and unlimited rather than by access and perhaps default settings. Any help would really, really be appreciated! thanks in advance folks!

11-05-2009, 12:32 AM	#2 (permalink)
2xgrump Mentor Networking Forums Join Date: Aug 2009 Posts: 1,000 OS: Vista-sp2/Win2003Server-R2/SBS2003/XP-sp3	Re: ACCESS 2007 Forms; Formatting Question Hi leftyrad, If you have several Tables you may link them by using Relationships and then you may choose whatever fields you need compiled in your Forms. __________________ Networking Forums "Peace" RD