I need to be able to type a series of numbers into a field and have
colons appear automatically between each set of 2 numbers counting from
the right. For example:
I type 1234500
I need to see: 1:23:45:00
I've tried field masking solutions but they seem not to work with
colons, since after I click out of the field I get a number that is some
calculated derivative of what I typed in.
Note that at the moment I do NOT need to calculate timecode, just
display it in its proper format. Can anyone help?
Reid C
|
|
0
|
|
|
|
Reply
|
Reid
|
1/1/2004 9:03:19 PM |
|
There is no native Filemaker display of timecode. You will need to create a
calculation, returning text, that does what you want by parsing out the data
entry field. A common method for pseudo-masking is to place the data entry
field directly behind the calc, transparent, but with entry allowed, while
the calc is set to not allow entry, and set with a solid fill.
--
John Weinshel
Datagrace
Vashon Island, WA
(206) 463-1634
Associate Member, Filemaker Solutions Alliance
"Reid Caulfield" <reidc@earthlink.net> wrote in message
news:reidc-895B88.13031901012004@news02.west.earthlink.net...
> I need to be able to type a series of numbers into a field and have
> colons appear automatically between each set of 2 numbers counting from
> the right. For example:
>
> I type 1234500
>
> I need to see: 1:23:45:00
>
> I've tried field masking solutions but they seem not to work with
> colons, since after I click out of the field I get a number that is some
> calculated derivative of what I typed in.
>
> Note that at the moment I do NOT need to calculate timecode, just
> display it in its proper format. Can anyone help?
>
> Reid C
|
|
0
|
|
|
|
Reply
|
John
|
1/2/2004 2:15:53 AM
|
|