In APEX 514 I have a few fields set as Display Only type control downwards on the form and I fill this fields over code. Numbers are between 0 and 999. I want to align them right, like numbers usually are. I tried to use LPad function in the form LPad(0, 3, ' '), but it doesn't add 2 spaces before. But if I use for example * (asterix) instead of space using LPad(0, 3, '*') or any other visible char, then this character is used and visible. Why used space isn't aplied the same way as for example in SQLDev? See below:
I can't find any property setting to achieve this. Do I have to use some special Chr code for such cases, that 0 will be right aligned and I won't see any visible chars in front?