I am not able align the decimal places when I centre the text in a cell. Is
it possible to align number 10.1, 100.1, 1000.1 to the centre of the cell in
a column as well as ensuring the decimals are aligned?

I don't believe that option's available in Access.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Ramesh Babu" <Ramesh (E-Mail Removed)> wrote in message
news:3194185D-E4BD-42DD-AAF9-(E-Mail Removed)...
>I am not able align the decimal places when I centre the text in a cell. Is
> it possible to align number 10.1, 100.1, 1000.1 to the centre of the cell
> in
> a column as well as ensuring the decimals are aligned?

Try this --
Right(Space(5) & Left([YourDate],InStr([YourDate],".")-1),6) & "." &
Right([YourDate],Len([YourDate])-InStr([YourDate],"."))

You will need to set the font as Courier so that all characters use the same
horizontal spacing.

"Douglas J. Steele" wrote:

> I don't believe that option's available in Access.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Ramesh Babu" <Ramesh (E-Mail Removed)> wrote in message
> news:3194185D-E4BD-42DD-AAF9-(E-Mail Removed)...
> >I am not able align the decimal places when I centre the text in a cell. Is
> > it possible to align number 10.1, 100.1, 1000.1 to the centre of the cell
> > in
> > a column as well as ensuring the decimals are aligned?
>
>
>

Of course it isn't possible.

Either you have to use padded strings with a non-proportional font or you
have to choose how you want to align the data.

--

Terry Kreft


"Ramesh Babu" <Ramesh (E-Mail Removed)> wrote in message
news:3194185D-E4BD-42DD-AAF9-(E-Mail Removed)...
> I am not able align the decimal places when I centre the text in a cell.
Is
> it possible to align number 10.1, 100.1, 1000.1 to the centre of the cell
in
> a column as well as ensuring the decimals are aligned?