Moving/formatting text boxes in form

[Guest]

I have constructed a form w/proper fields with proper calculations, BUT am
having the biggest issues trying to finagle and move the text and field boxes
around to where I want them on the form, which seems so basic.

I used the "justified" template, which may be the root of my problem. My
form captures start times, end times, and total hours per day worked, 7 days
a week. Basically, they are all in a jumble, and I want to put them in
organized colums with Sun - Sat. start times going down column 1, Sun-Sat.
end times going down column 2, and Sun - Sat. total hrs per day going down
column 3. Very simply, very basic, just want it orderly and neat.

I understand that by clicking the box and moving the mouse I can move and
resize the boxes, but they seem to do some weird autoformatting things. When
I try to move fields, it seems that each text box does their own thing. The
title box, say "Saturday Start Time" that corresponds to the field box where
the start time would be entered will move away from each other and I cannot
get the field and it's appropriate title to stay together when I move them!

Very frustrating, the form is fine, but it looks crazy. Can anyone help??

Much thanks,

Kate

 

[Larry Linson]

Forms are not the "focus" in Access -- can you clarify details of the tables
and fields in those tables that you are dealing with? Also, exactly what is
"the justified template" -- I see no such option when creating a new form in
Access 2002.

Larry Linson
Microsoft Access MVP

 

[Guest]

The "Justified" form I am referring to is an option when creating a form via
"Form Wizard", I believe I am running Access 2000.

The tables I have made my form from are a table of employees and their
weekly hours, with a query of daily and weekly hour totals, which all appear
on the form.

I think I am actually having some luck with the form. I think that some
type of autoformat is on, and is therefore not letting me move boxes where I
want and spacing them oddly.

Thanks!

 

[Craig Hornish]

Hi,
The "Justified" and "Columnar" are used to show 1 record at a time -
the Tabular and Datasheet are used to show columns of data.
You say you want to keep the Label(correct naming for title) box with
the Text[also generic Control](correct naming for field - but combo box,
checkbox could also hold the bound data) box. They usually are execpt in
the Tab/Data situation but that can be broken by deleting the Label and
putting it back. In Access 2003 at least you can re Associate the label to
the Control.
But this really sounds like you need a column type form and that will be
either the Tabular (more probable) or Datasheet (really used most for
subforms).

Craig Hornish

PS Larry if you read this - look again "Justified" is in 97 It is one of the
options in the wizard after you select the fields.