Alignment of data

[Steve]

Trying to change the alignment of dates in a column from right justify
(which is apparently the default) to center. In form view, right-click
the date column > Properties > Text Align > Center. But this has no
effect. Must be missing something? Thanks!


--

The art of conversation is not only to say the right thing
at the right time, but to leave unsaid the wrong thing
at the tempting moment.

....Dorothy Nevill

 

[John W. Vinson]

Trying to change the alignment of dates in a column from right justify
(which is apparently the default) to center. In form view, right-click
the date column > Properties > Text Align > Center. But this has no
effect. Must be missing something? Thanks!

If you're trying to do this in a Table... don't bother. Table and Query
datasheets are NOT designed for data presentation.

Create a Report for printing, or a Form for onscreen display; put the date
field in a textbox, and set that textbox's alignment as you want to see it.

 

[Steve]

If you're trying to do this in a Table... don't bother. Table and Query
datasheets are NOT designed for data presentation.

Ugh. It would make it much easier to view the data onscreen...


--

Even he, to whom most things that most people
would think were pretty smart were pretty dumb,
thought it was pretty smart.

....Douglas Adams

 

[John W. Vinson]

Ugh. It would make it much easier to view the data onscreen...

How so? A Form is EASIER to use than a table, if it's designed correctly - no
problem with scrolling right or left, controllable textbox sizes, etc. Five
minutes work now creating a form will save you vastly more time over the long
run.

 

[Steve]

How so? A Form is EASIER to use than a table, if it's designed correctly - no
problem with scrolling right or left, controllable textbox sizes, etc. Five
minutes work now creating a form will save you vastly more time over the long
run.

I must be missing something - what about viewing more than one record
at a time?


--

Even he, to whom most things that most people
would think were pretty smart were pretty dumb,
thought it was pretty smart.

....Douglas Adams

 

[John W. Vinson]

I must be missing something - what about viewing more than one record
at a time?

If you use a Continuous Form you can view as many records as will fit on the
screen. You can make it look very like a datasheet if you wish.... but with
more flexibility than a datasheet (you can set the format of the controls
independently, for example). If you're assuming that you must use a datasheet
or a single form only, revise your assumption!

 

[Steve]

If you use a Continuous Form you can view as many records as will fit on the
screen. You can make it look very like a datasheet if you wish.... but with
more flexibility than a datasheet (you can set the format of the controls
independently, for example). If you're assuming that you must use a datasheet
or a single form only, revise your assumption!

Thanks John. I have no idea how to do this - is there some sorta
step-by-step explanation available somewhere online?

 

[John W. Vinson]

Thanks John. I have no idea how to do this - is there some sorta
step-by-step explanation available somewhere online?

It's pretty simple. Open the form (or subform) in design view. View its
Properties, and set the Default View property to Continuous.

You'll want to arrange the textboxes and other controls at the top of the
Detail section, in one or a small number of rows, and drag the bottom of the
detail section up so it's at or near the bottom of the controls.