Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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