Format([TableName.FieldName],"s0")

[Remster]

Folks



A simply one, I hope.

If I use Format([TableName.FieldName],"v0") in a query, I get the results I want: v1, v2, v3, etc. But if I use Format([TableName.FieldName],"s0"), I get this: 01, 02, 03, etc. How do I get s1, s2, s3, etc. instead?

Thanks

Remster

[goodguy]

It worked with both 's' and 'v' when I tested it.
When I type 'v0', it is automatically set to '\v0'.

[boblarson]

Use

Format([TableName].[FieldName],"\s0")


The \ will force the s to be literal. I am guessing that there is some meaning to just the s being there with the 0 which causes the leading zero.

[Remster]

Ouch! Schoolboy error on my part. I was about to protest that I'd already tried "\s0", but I had my slash the wrong way round. Problem solved.

I think "s" on its own might represent seconds, as in "hh:mm:ss".