Expand my Community achievements bar.

SOLVED

Getting zero to display as the first character

Avatar

Level 1

I know this should be simple, but I'm trying to get a zero to display as the first character in a field when necessary.  For example last 4 of SSN.  Any help would be appreciated.

1 Accepted Solution

Avatar

Correct answer by
Level 10

Hi,

You can achieve this in the Patterns dialog. Select the object and go to the Object > Field palette. There you can click the Patterns button and edit the Display Pattern.

For example, this would display a number without leading zeros: 12

num{zzz9}

Whereas if you use 9 it will display leading zeros: 0012

num{9999}

Hope that helps,

Niall

View solution in original post

3 Replies

Avatar

Level 4

Hello Tony,

can you please elaborate your doubt, means would you

like to make a field zero as the starting character.

please give a clear example.

Thanks,

Debadas

Avatar

Correct answer by
Level 10

Hi,

You can achieve this in the Patterns dialog. Select the object and go to the Object > Field palette. There you can click the Patterns button and edit the Display Pattern.

For example, this would display a number without leading zeros: 12

num{zzz9}

Whereas if you use 9 it will display leading zeros: 0012

num{9999}

Hope that helps,

Niall

Avatar

Level 1

Sorry Debadas about the lack of clarity. 

@Naill, yes it does.

Thought the Allow Zeros check box would have been the answer, but it wasn't