Automatic field formatting for timecode

  • Follow


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


1 Replies
492 Views

(page loaded in 0.056 seconds)

Similiar Articles:





7/22/2012 11:25:54 AM


Reply: