alight text data to right

[Dan]

i have a table and a text field that i want the data to be
aligned to the right and not to the left how can i do
this?

 

[Bruce M. Thompson]

i have a table and a text field that i want the data to be

aligned to the right and not to the left how can i do
this?

You should be editing and viewing your data through a form, not directly in the
table view, so simply set the "Text Align" property of the textbox displaying
this field on the form to "Right".

 

[Dan]

This is a very small table maybe 200 records that im not
going to enter anymore records i am going to upload it
into another database but want to have it aligned to the
right

 

[Bruce M. Thompson]

This is a very small table maybe 200 records that im not

going to enter anymore records i am going to upload it
into another database but want to have it aligned to the
right

You'll still need a form to do that.

 

[Dan]

I tried that with a form but it aligns the text in the
form and not the table

 

[Bruce M. Thompson]

I tried that with a form but it aligns the text in the

form and not the table

That is correct. You can't "align" text in a table. You can only "align" the
display of the value in a form or report control. As the alignment of data has
nothing to do with storing or using the same, I wonder why you want to do this -
can you enlighten me?

 

[Bruce M. Thompson]

I tried that with a form but it aligns the text in the

That is correct. You can't "align" text in a table. You can only "align" the
display of the value in a form or report control. As the alignment of data has
nothing to do with storing or using the same, I wonder why you want to do this -
can you enlighten me?

I have been reminded by one of my peers that there is indeed a way to "align"
the display of data in the table view, but I want to make it clear that I, in no
way, condone the same for any more than providing a global method of aligning
the data when displayed in a form or report control, subject to any formatting
set up in any such control's properties. In table design view, you can set the
"format" property for the field to "* " (that's an asterisk followed by a
space - just ignore the change to "**" that Access will make to that). The data
in that field should then appear right-aligned.

Just remember that you didn't hear that from me. <g>

 

[Dan]

thank you for your help im working with one of our
programmers and they need to have the field right aligned
for some reason im not exactly sure but thank you