Tables (grid) in forms

Egg 'n' Bacon
5StarLounger
Posts: 736
Joined: 18 Mar 2010, 11:05

Tables (grid) in forms

Post by Egg 'n' Bacon »

Not to be confused with tables to hold data, but like used in Word.

I was hoping that 2007 would have something like, but I can't find anything.

Does anybody know a quick way of creating one of thses tables in an Access form?

User avatar
HansV
Administrator
Posts: 78591
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Tables (grid) in forms

Post by HansV »

Access is strictly a data-oriented application; it does not provide a Word-like table.

Microsoft has several grid-type controls, but they are not part of Access, and they are not available to all users, so I'd avoid them.

You can insert a Word document or an Excel worksheet onto a form, but what do you want to accomplish with it?
Best wishes,
Hans

Egg 'n' Bacon
5StarLounger
Posts: 736
Joined: 18 Mar 2010, 11:05

Re: Tables (grid) in forms

Post by Egg 'n' Bacon »

The main scenario is that to provide a blank printable form/checksheet for a user to fill-in in a production area, then later copy that data into the db.

User avatar
HansV
Administrator
Posts: 78591
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Tables (grid) in forms

Post by HansV »

You could design a report, temporarily add a number of blank records to the table, and print the report. The blank records can be discarded afterwards.

It might be easier to design the printable 'form' in Word or Excel.
Best wishes,
Hans