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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. plengeb

    vbCrLf / + Chr(13) + Chr(10) Carriage Returns in A Report

    Thank you so much to everyone that responded. I found a solution on another forum that works, and I want to share it, with the hopes that it will help you in the future. The solution is to use the break code like you use for html, and then set the field on the report to Rich Text. The Rich...
  2. plengeb

    vbCrLf / + Chr(13) + Chr(10) Carriage Returns in A Report

    It's currently stored in a table as a memo field. I have it as = "HX: PF | EPF | DET | COMP" + Chr(13) + Chr(10) & "EX: PF | EPF | DET | COMP" in the field. When I run the report, I want it to show as two lines. HX: PF | EPF | DET | COMP EX: PF | EPF | DET | COMP Do you know of a way to get...
  3. plengeb

    vbCrLf / + Chr(13) + Chr(10) Carriage Returns in A Report

    I tried it, and it's still doing the same thing on mine. I presently have the field formatted as memo. How is yours formatted?
  4. plengeb

    vbCrLf / + Chr(13) + Chr(10) Carriage Returns in A Report

    = "HX: PF | EPF | DET | COMP" + Chr(13) + Chr(10) & "EX: PF | EPF | DET | COMP" I am storing the above string in a table. The forms and reports are currently displaying the string exactly as above. When a form or report pulls the field, I would like it to do the carriage returns and appear as...
  5. plengeb

    Report Field Not Growing Correctly With Transparent Border

    Do you know of a way to attach files here? I made pdf's which would show what's happening.
  6. plengeb

    Report Field Not Growing Correctly With Transparent Border

    I'm using Access 2010. I have a text box (don't know what type). The text is Arial with a font size of 8. I changed the border color as you suggested, and that seems to be working. Thanks for the suggestion. Please let me know if you find out why the transparent border isn't working right...
  7. plengeb

    Report Field Not Growing Correctly With Transparent Border

    Hello, I have a report, and the "reason" field is one that can grow as needed. The following string is in the field: "MISSING IMPLEMENTATION PLAN, MISSING SERVICE LOGS FOR DATE OF SERVICE". I bolded “MISSING”, where the space hits the border. My standard setting for the border style is...
  8. plengeb

    Master and Child Field Links for Sub-report Not Working

    Duane, There was not such a text box in the section with the subreport. I put one there, and it solved the problem. Thank you very much.
  9. plengeb

    Master and Child Field Links for Sub-report Not Working

    Hello, I have a database in which it has a sub-report within a report. The main report is “rpt_detail Overpays”, and has the overpayments. The sub-report is “rpt_LegitClaims”, and has the legitimate claims. I am attempting to link the two reports (Master and Child fields) with the...
  10. plengeb

    Forcing A New Page After a Section

    I have an access report where I need to force a new page after the section is finished. However, after the last record is printed, that section forces a final, blank page. Does anyone know of a way to prevent the last forced page if it has encountered the final record? Thank you.

Part and Inventory Search

Back
Top