My forms don't appear the way I designed them to... I think

A

Andreww

Hi - I am a relative newbie to Access and forms however I know data and
FoxPro/SQL Server well.

One of the databases I manage has to stay in Access (long story..!) I have
designed a form which has a main table with organisations and two customer
tables linking in to it using the org_num.

I added the customer tables as sub forms in the designer window. I don't
know where it all goes wrong, but even though I may have specified a field
to be bold and in blue, or changed the size of the text box a field sits in,
it always seems to ignore my changes and I get forms which while they will
do aren't really what I intended.

Have I missed a set up "switch" somewhere, or am I going about this the
wrong way?

Any ideas/help appreciated. If I can get this right I am much more likely
to want to work in Access for other projects.

Regards

Andrew
 
A

Albert D. Kallal

It is possible that are you editing the sub-form in continues form mode, but
displaying the form as a datasheet.

You likely want to change the default view of the sub-form to continues
form, and NOT use the datasheet view. (if you change the color, or formation
of a text box in the form,b ut view in datasheet view...you don't see the
changes).

So, select the form in design mode, and then look at the "format" tab for
the "default view". You want this to be continuous...and likely not a
datasheet.

You can see some continues forms screen shots in the following to get some
ideas here as to what they should look like:

http://www.attcanada.net/~kallal.msn/Articles/Grid.htm

And, here is some info on sub-forms:

http://www.attcanada.net/~kallal.msn/Articles/fog0000000005.html
 

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