Purpose of Header / Footer / Detail

[oskar]

I have finished my first form design and my intention is to make an executable of this file. Attached I have a snip of my form in Layout view and my question is how do I make some kind of a border around my form?

In addition I don’t understand the purpose of the Form Header / Footer and Detail. I have put the title of my form between the Form Header and Detail and I wonder if this is the right place plus is it a good idea to delete the Header / Footer?

 

[vbaInet]

You have a couple of options:
1. Use a Rectangle control to create a border but it will be restricted to the section where you placed the control.
2. Put your form in a subform and use the Border properties of the subform control as your border.
3. Set the Border Style property of the form itself to Thin but this would only take effect if it's a 'floating' form, i.e. Popup form (Popup property to Yes).
4. Create an image with a box drawn on it to fit, and use that as the background picture of your form

The form Header and Footer section are pretty much the same except that one is above and other is below the Detail section. Controls placed in either of those sections stay fixed, i.e. they don't scroll like the Detail section would so it's perfect for things like getting totals or for referencing the current value in a continuous/datasheet form. Last, but not the least, the Header paints and runs code before the Footer does.

 

[CJ_London]

but this would only take effect if it's a 'floating' form, i.e. Popup form (Popup property to Yes).

Or the db is set to overlapping windows rather than tabbed documents

 

[oskar]

Lots to consider here, again I will make a copy of my dB and play around until I get it right. I thought there was a command / control to do the border which I could not find
Thanks again

 

[vbaInet]

Good addition from CJ_London!

I'm pleased that you make it a habit of making a copy of your db before you "mess around" with it. Good on you!

 

[oskar]

Beginners luck only goes so far, making a copy is my backup plan.......

 

[pbaldy]

Let us know how this goes.

my intention is to make an executable of this file.

If you mean an exe, it can't be done. You can use the free runtime version of Access, but your file will always require Access to be used.

 

[oskar]

I'm working on this right now. I also have Access 1998 (I think its 98 or 2000) and I did make an exe for something similar many years ago. I though the newer Access will have the same or even better. Anyway thats not a big deal but thanks for the tip

 

[pbaldy]

To my knowledge it's never been supported, but it wouldn't be the first time I was wrong.

 

[oskar]

Item 1 from post #2 did the trick. Now the form is enclosed in a rectangle but would like to see what the exe will include. I will try to do that tomorrow or over the weekend