How to control format of Table columns?

[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?

 

[Wayne-I-M]

Hi

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?

You really don't to worry about a table looks like as look as it hold the
data you want it to - that "all" it's there for. Never work directly on a
table other than for application building and maintainence.

You should work on your data in a query or form
To left justify on a form design just click the left format option

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?

You can set the format either in the table so that it goes into every use of
this data or set it on your form or query - set the format of your data as
Yes/No
True/False
Yes/No
or some other bespoke format

Hth

--
Wayne
Manchester, England.

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?