i have a string:
SINGOLA
DOPPIA
TRIPLA
SUITE
SUPER SUITE
the max lenght of string is SUPER SUITE (11)
how to fill with space, the rest of string, in new var
exmple:
SINGOLA have a lenght 7, i need to fill SINGOLA and 4 space.
In effect i need a tabular list
same length of string
-
- Administrator
- Posts: 78545
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: same lenght of string
Let's say you have a variable myvar.
myvar = Left(myvar & Space(11), 11)
myvar = Left(myvar & Space(11), 11)
Best wishes,
Hans
Hans
-
- PlatinumLounger
- Posts: 4362
- Joined: 26 Apr 2010, 17:36
Re: same lenght of string
hummmm....
i have use:
TIPO = Left(RS!TIPO & Space(11), 11)
INDICE = RS!IDTIP & "-" & TIPO & "-DAL: " & RS!DAL & "-AL: " & RS!AL
but in treeview i dont see a tabular item....
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78545
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: same length of string
You will have to specify a fixed-width font for the TreeView control, for example Consolas or Courier New.
Best wishes,
Hans
Hans
-
- PlatinumLounger
- Posts: 4362
- Joined: 26 Apr 2010, 17:36