How to Control Format of Table columns

  • Thread starter Thread starter WDSnews
  • Start date Start date
W

WDSnews

I have two examples that need resolved.

First, I have a table in which one column displays all of its records, right
justified. How can I return it to normal left justified format?

Second, I have a query with a calculated field [iif( x, True, False)].
Running the query returns either a 0 or -1. I'd prefer to view it as a
column of checkmarks. How can I control the view of a true or false query
result?
 
At the top, you have three buttons, one for left, one for right, one for
centered. Highlight the column and pick left.
For checkmarks, I don't know, but you can do another column and do
IIF([yourfield]=0, "yes", "no") and that will get you yes's and no's instead
of o's and -1's.
 
Back
Top