RE: How to format display ?
- From: Klatuu <Klatuu@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 12 Apr 2005 09:43:01 -0700
additem space(25-len(part_nbr) & part_nbr) & space(31-len(description) _
&formatdatetime(date, vbGeneralDate)
This will do it. Notice space(31 for description. It is 1 longer than the
field length, so will always show a space. Also, quit using +, it is a math
sign. Proper coding for string concatenation is &. I know + works, but it
is a holdover from Basic version B.C.
"Mac" wrote:
>
> Part_number Char 25
> Description Char 30
> Date Date 8
>
> output = additem part_nbr+' '+description+date
>
> All the part numbers or descriptions do not have the same lengths so when I
> print it, mess up my listbox's display.
>
> How can I print or fix the length of part number, description etc so it
> prints the same number of characters?
>
> Thx
>
>
>
>
.
- References:
- How to format display ?
- From: Mac
- How to format display ?
- Prev by Date: Re: How do i convert an DOS isam Daconti database to access?
- Next by Date: RE: access 2003 report printer properties
- Previous by thread: Re: How to format display ?
- Next by thread: Error 3049
- Index(es):
Relevant Pages
|