How can I simple create a table like structure in my form

  • Thread starter Hoardling1 via AccessMonster.com
  • Start date
H

Hoardling1 via AccessMonster.com

Access 2007
I want a table looking object in my form so I can put buttons text boxes etc..
.. in it.
It is not a table, just has that grid look.

If at all possible I really don't want to create a bunch of boxes manually
and populate with them.
Is there an object that replicates a table look.
 
J

Jeff Boyce

For what purpose? Are you trying to give your users something that looks
like a spreadsheet?

If so, having them use Access as if it were a spreadsheet may lead to more
issues later...

Regards

Jeff Boyce
Microsoft Access MVP
 
J

John W. Vinson

Access 2007
I want a table looking object in my form so I can put buttons text boxes etc..
. in it.

Those would seem to be contradictory requirements: a Table has textboxes but
not buttons.
It is not a table, just has that grid look.

If at all possible I really don't want to create a bunch of boxes manually
and populate with them.
Is there an object that replicates a table look.

I would suggest a Continuous Form. You'll need to (one time only) create a
textbox bound to each field, and snug them up to the top of the detail section
of the form and to each other. You can intersperse combo boxes, command
buttons, option groups, etc. if those are suitable for the data. Drag the
bottom of the Detail section up to the bottom of the textboxes and you'll get
a pretty good imitation of a datasheet in appearance, but still have the
flexibility of control types; *and* you can display the form Header and Footer
for custom labels, subtotals, calculated fields, search combos, etc.
 
L

Larry Linson

Hoardling1 via AccessMonster.com said:
I want a table looking object in my form so I can
put buttons text boxes etc.. in it.
It is not a table, just has that grid look.
If at all possible I really don't want to create a
bunch of boxes manually and populate with them.
Is there an object that replicates a table look.

There's no "grid look" object built in to Access. Access can use some (but
not all) ActiveX controls, and there are various grid-look controls
available from third-party vendors, if you are that serious (they have much
more capability than you describe, and are not necessarily inexpensive).

Although you say you don't wish to do so, you can, and some have, grouped
controls within the rectangles and lines that are built in Access controls.
Given that your wish for a built-in grid is just not the way things are, you
may just have to work with the way things actually are.

But, as others have commented, it would be helpful if you would explain what
you are trying to accomplish, if it is not just to satisfy your own idea of
appropriate design. There are many experienced and talented developers who
participate in this newsgroup, and it's entirely possible that some of them
might be able to make useful suggestions for accomplishing your purpose in a
different way.

Larry Linson
Microsoft Office Access MVP
 
H

Hoardling1 via AccessMonster.com

I only need a grid view for visual purposes only. Something with borders and
a transparent background. The grid view will not link to data. Just eye
candy to help split up a form.
 
J

John W. Vinson

I only need a grid view for visual purposes only. Something with borders and
a transparent background. The grid view will not link to data. Just eye
candy to help split up a form.

The Rectangle tool would appear to be suitable, in that case.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top