Really should be:

Right(CLng(Date) & Format(Time * 86400, "00000"), 9)

In article ,
JE McGimpsey wrote:

I'd think that

Right(CLng(Date) & CLng(Time * 86400), 9)

ought to last you for a while, as long as nobody generates a form at
exactly the same second.