I would like to define a format for a numerical field, so it shows the entered value as SMPTE timecode.

can anyone help me as how to do this?

it would be nice if one could just enter for example 61504 and the field would show '00:00:06:15:04

-

mikkel

I would like to define a format for a numerical field, so it shows the entered value as SMPTE timecode.

can anyone help me as how to do this?

it would be nice if one could just enter for example 61504 and the field would show '00:00:06:15:04

-

mikkel

I would like to define a format for a numerical field, so it shows the entered value as SMPTE timecode.

can anyone help me as how to do this?

it would be nice if one could just enter for example 61504 and the field would show '00:00:06:15:04

-

mikkel

S

S

S

MikkelBreum.zip

how?

how?

how?

I stumbled with this too. Soren forgot to include the word Attachment. See it in the box above his message?

Lee

I stumbled with this too. Soren forgot to include the word Attachment. See it in the box above his message?

Lee

I stumbled with this too. Soren forgot to include the word Attachment. See it in the box above his message?

Lee

oh, I got it. thank you very much.. To aanyone hwo needs this:

Replace (

Replace (

Replace (

Replace ( Right("0000000000" & GetAsText ( theFieldname );10)

; 9 ; 0 ; ":" )

; 7 ; 0 ; ":" )

; 5 ; 0 ; ":" )

; 3 ; 0 ; ":" )

oh, I got it. thank you very much.. To aanyone hwo needs this:

Replace (

Replace (

Replace (

Replace ( Right("0000000000" & GetAsText ( theFieldname );10)

; 9 ; 0 ; ":" )

; 7 ; 0 ; ":" )

; 5 ; 0 ; ":" )

; 3 ; 0 ; ":" )

oh, I got it. thank you very much.. To aanyone hwo needs this:

Replace (

Replace (

Replace (

Replace ( Right("0000000000" & GetAsText ( theFieldname );10)

; 9 ; 0 ; ":" )

; 7 ; 0 ; ":" )

; 5 ; 0 ; ":" )

; 3 ; 0 ; ":" )

Soren,

Replace() nothing with something (i.e, "Insert")? That's great, I have to remember this!

Just a note: there are only 4 pairs in timecode (hours:minutes:seconds:frames), so if anyone needs this, it should be:

Replace (

Replace (

Replace ( Right("00000000" & GetAsText ( theFieldname ) ; 8 ) ;

7 ; 0 ; ":" ) ;

5 ; 0 ; ":" ) ;

3 ; 0 ; ":" )

There is also an older thread here that includes entry validation.

Soren,

Replace() nothing with something (i.e, "Insert")? That's great, I have to remember this!

Just a note: there are only 4 pairs in timecode (hours:minutes:seconds:frames), so if anyone needs this, it should be:

Replace (

Replace (

Replace ( Right("00000000" & GetAsText ( theFieldname ) ; 8 ) ;

7 ; 0 ; ":" ) ;

5 ; 0 ; ":" ) ;

3 ; 0 ; ":" )

There is also an older thread here that includes entry validation.

Soren,

Replace() nothing with something (i.e, "Insert")? That's great, I have to remember this!

Just a note: there are only 4 pairs in timecode (hours:minutes:seconds:frames), so if anyone needs this, it should be:

Replace (

Replace (

Replace ( Right("00000000" & GetAsText ( theFieldname ) ; 8 ) ;

7 ; 0 ; ":" ) ;

5 ; 0 ; ":" ) ;

3 ; 0 ; ":" )

There is also an older thread here that includes entry validation.

Soren,

Replace() nothing with something (i.e, "Insert")? That's great, I have to remember this!

Same here, always been inserting something from one end to the next start...

Soren,

Replace() nothing with something (i.e, "Insert")? That's great, I have to remember this!

Same here, always been inserting something from one end to the next start...

Soren,

Replace() nothing with something (i.e, "Insert")? That's great, I have to remember this!

Same here, always been inserting something from one end to the next start...