Re: dot leaders in an Access report



I do it by making my name field stretch all the way to my phone field. My
name field contains the following...

=[LastName] & ", " & [FirstName] &
"...........................................................................
............."


Then you get...

Smith, John............................................ (713) 555-1212


--
Rick B



"Roni" <Roni@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EEDEBDBE-DE59-4CDB-9B17-7AAD9F285E96@xxxxxxxxxxxxxxxx
> I have a database in Access for people's names and phone numbers just like
a
> phone book. I am attempting to create a report to print that includes the
> person's last name, trimmed, plus their first name. Then I would like a
dot
> leader with their phone number right justified.
>
> I have been unable to find the instructions to do this.


.



Relevant Pages

  • Re: OT: Oh Hell Yeah
    ... That's correct, Rick. ... But we first have to give them instructions on ... how to get out of Pittsburgh. ... Prev by Date: ...
    (rec.arts.marching.drumcorps)
  • Re: Treo 650 and SBS2k3
    ... Could you post these "step by step instructions"? ... to me as I am planning on trying this! ... "Rick F" wrote: ... Prev by Date: ...
    (microsoft.public.windows.server.sbs)
  • Re: moving to end of sheet
    ... >There are instructions here for resetting the used range: ... >Rick wrote: ... >> worksheet. ...
    (microsoft.public.excel.newusers)
  • Re: moving to end of sheet
    ... There are instructions here for resetting the used range: ... Rick wrote: ... > worksheet. ...
    (microsoft.public.excel.newusers)
  • Re: Prime numbers
    ... can always produce a composite (non-prime) number that has different ... divisors... ... Rick ... Prev by Date: ...
    (comp.lang.basic.visual.misc)