Re: [MSAccessProfessionals] indent string to the right by space characters

You should consider using the String() function. https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/string-function

Duane

Sent from my mobile

On Sep 23, 2021, at 6:42 PM, smiley2004_10 <cas23121964@gmail.com> wrote:



Hi

 

I would like to achieve the following!

Is to move the string value to the right X number of spaces to right based upon a user input criteria.

 

Is there a function or SQL I could use to achieve the following without a case format, as that would be to limiting.

 

"1"                  (being level 0)

  "1.1"    (being Level 1)

     "1.1.1"      (being level 2)

 

Thanks