? to align decimals when we centre the text in a cell 10.1, 100.1

[Guest]

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?

 

[Douglas J. Steele]

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

 

[Guest]

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.

 

[Terry Kreft]

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.