Text Box is trimming my text.

retko1985 — Mon, 09 Oct 2017 12:08:02 GMT

Hello,

I want to align my text by adding some spaces after the word, but it is not moving, but trimming.

I dont want to use text margin, because I want to muve just one part:

I want to have something like this in text box:

=if(vText=1,'Big Text','Small

When clicked, it will switch text. Now I need to make it appear good by adding spaces.

Is here some way?

Thank you.

Re: Text Box is trimming my text.

prieper — Mon, 09 Oct 2017 12:13:45 GMT

Try to add an invisible character:

= IF(vText = 1, 'Big Text', 'Small ' & CHR(127))

edit: typo: CHR(157) works on my computer as well, think that CHR(127) is better.