Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
multi-column listbox column justification
- Thread starter rafe
- Start date
The only way you can do it is to "pad" the data with leading spaces.
heres how
but DO NOT DO IT where it affects the data.
you need to know the full lenght of the cloumn in th elist box
Say its 20 characters long And your Currency field is MyMoney
So to add spaces to the friont would be
NewValue = space(20-len(MyMoney)) & MyMoney
DougP, MCP
dposton@universal1.com
Ask me how Bar-codes can help you be more productive.
heres how
but DO NOT DO IT where it affects the data.
you need to know the full lenght of the cloumn in th elist box
Say its 20 characters long And your Currency field is MyMoney
So to add spaces to the friont would be
NewValue = space(20-len(MyMoney)) & MyMoney
DougP, MCP
dposton@universal1.com
Ask me how Bar-codes can help you be more productive.
- Status
Similar threads
- Locked
- Question
