Results 1 to 3 of 3

Thread: Access 2003 - Report field -Line feed & carriage return

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    Aug 2006
    Location
    India, Punjab, Bhatinda
    Posts
    1,689

    Question Access 2003 - Report field -Line feed & carriage return

    Hello Everybody,
    I created a report in Access 2003. One the fields contains phonenumbers. The phone numbers are stored in diif fields of db. I concatenated then in the above field using Properties->control source->Build
    Code:
    =[hPh1] & ',  ' & [oPh1] & ', ' & [mob1]
    The problem is the phone numbers need to be displayed one on each line. I used chr(10) & chr(13), all I get is two square boxes. I set the CanGrow and CanShrink to YES.
    Can somebody help

    DB: Access 2003
    Report: Access 2003

  2. #2

    Thread Starter
    Frenzied Member
    Join Date
    Aug 2006
    Location
    India, Punjab, Bhatinda
    Posts
    1,689

    Re: Access 2003 - Report field -Line feed & carriage return

    Is there no way to introduce a line feed & carriage return in report?

  3. #3
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    Re: Access 2003 - Report field -Line feed & carriage return

    I used chr(10) & chr(13),
    The order of the CRLF characters is backwards. Try chr(13) & chr(10) instead.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width