Jeanne,
Thanks for the info. This pretty much how I wanted it to work.
Is there a way to have it flag when what was entered isn't a valid
date? For example February 32, 2006 or Fuberry 2, 2006.
Bill Vlahos
On Feb 2, 2006, at 7:05 AM, Jeanne A. E. DeVoto wrote:
At 11:43 PM -0800 2/1/2006, Bill Vlahos wrote:
The table object has the ability to format cells several ways
including Date. There is a field to the right of this choice in
the Properties Palate but I don't know what information should go
in there. I wasn't able to find any references to it in the Help.
What I want is to validate and format the cell information so that
it is a correct date. Is this how it is supposed to work? If so,
what do I put in the field?
It's a date modifier (short, abbrev, long, or system). For example,
if you set the combobox to "Date" and enter "short" in the field,
then if you enter "Feb 6, 2006" in a cell in the formatted column,
then click out of it, the cell is changed to read "2/6/2006". From
the (old) docs (this seems to have gotten dropped out of the docs
at some point):
-
How to format numbers in a table field:
To control the format of numbers in a table field, you specify a
format, along with the cells you want to apply the format to, in
the field's property inspector. To choose a format, follow these
steps:
1. In the "Table" pane, check the "Cell formatting" box.
2. Choose a column number from both menus labeled "Format Column".
3. From the "Using" menu, choose the format you want to use. In
the "With" box, enter a prefix or suffix, a number of decimal
places, a percentage value, or "short", "long", "internet", or
"system" for a date.
4. Press the Tab key, then click "Add" to apply the format.
Note: You can apply only one format to any particular cell.
-
--
jeanne a. e. devoto ~ [EMAIL PROTECTED]
http://www.jaedworks.com
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
