Page 2 of 2 FirstFirst 12
Results 16 to 25 of 25
  1. #16
    sugr74 is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2018
    Posts
    24
    Yes the test works fine.



    the strcompactadd is a new field in the query,

    strCompactAdd: CanShrinkLines([ADDRESS2],[ADDRESS2],[TOWN],[COUNTY],[PC])

  2. #17
    sugr74 is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2018
    Posts
    24
    Yes, the test works fine??

    I added the strcompactadd into a new field within the query

    strCompactAdd: CanShrinkLines([ADDRESS2],[ADDRESS2],[TOWN],[COUNTY],[PC])

  3. #18
    Minty is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    That looks fine. If you open the forms underlying query in datasheet view do you get sensible results?

    Edit : Have you enlarged the text box to allow you to see the full result ?
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  4. #19
    sugr74 is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2018
    Posts
    24
    Yes, it just only shows one of the field instead of all 5 combined???

  5. #20
    Minty is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    Okay that is weird.
    Can you upload some a stripped down database with some sample data and the query / form or report you are using for me to have a look?
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  6. #21
    sugr74 is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2018
    Posts
    24
    I can't get it below 500K? So it wont upload?

  7. #22
    sugr74 is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2018
    Posts
    24
    I can't get it below 500K? So it wont upload?

  8. #23
    sugr74 is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2018
    Posts
    24
    Ok, got it. So it's the new order acknowledgment thats the issue, when running the report the print preview still shows the lines.
    Last edited by sugr74; 11-15-2018 at 01:13 AM.

  9. #24
    Minty is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    It is working in the datasheet, just make the datasheet line height bigger.

    The same applies to the textbox on the report make it taller !
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  10. #25
    sugr74 is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2018
    Posts
    24
    Quote Originally Posted by Minty View Post
    It is working in the datasheet, just make the datasheet line height bigger.

    The same applies to the textbox on the report make it taller !
    Omg what an idiot!!! Lol

    Thank you so much

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Blank space between fields in report header
    By cebrower in forum Reports
    Replies: 3
    Last Post: 09-18-2018, 09:48 AM
  2. Replies: 1
    Last Post: 01-31-2018, 04:06 PM
  3. Generate report with blank linked table fields
    By e-support in forum Reports
    Replies: 14
    Last Post: 01-06-2017, 04:11 PM
  4. Border not appearing on blank fields - Report
    By jmitchelldueck in forum Reports
    Replies: 1
    Last Post: 08-26-2015, 08:15 AM
  5. Replies: 2
    Last Post: 02-03-2011, 12:41 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums