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!

Register Log in
  • Congratulations Chriss Miller 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. darkmindx

    Spell-check Entire Database

    Does anyone know why I might be getting the error mentioned above? Thanks
  2. darkmindx

    Spell-check Entire Database

    When I run the above code, it works fine for a few items, but then I get an error that the program has encountered a problem and must close! Why do you think I am getting this error? Thanks
  3. darkmindx

    Spell-check Entire Database

    Hi Phil, I am currently using the following code: Private Sub Command32_Click() For qryQuery1 = 1 To 99 If Len(Me!txtBookReview & "") > 0 Then DoCmd.RunCommand acCmdSpelling Else Exit Sub End If Next qryQuery1 End Sub And it is working great! However, I...
  4. darkmindx

    Spell-check Entire Database

    Hi, Is it possible to spell-check the entire database using something along the lines of: If Len(Me!txtBookReview & "") > 0 Then DoCmd.RunCommand acCmdSpelling Else Exit Sub End If Thanks
  5. darkmindx

    Change Font Size When Exported to Word

    Does anybody know how to do this? I would really appreciate it. Thanks
  6. darkmindx

    Change Font Size When Exported to Word

    Hi, I want to output a report as an rtf file. I do this with: DoCmd.OutputTo acReport, "Testing", acFormatRTF, "C:\Program Files\Test.rtf", True I have my report in 8 point font. When it exports it to an rtf file, how can I change the font to 12 so when the rtf file automatically opens, all...
  7. darkmindx

    Report Truncates Words

    The words are only being truncated when the report is exported to word. They are not truncated when I view the report on screen from Access and they are not truncated when I print the report directly from Access.
  8. darkmindx

    Report Truncates Words

    Everything works great in the report. Nothing is truncated. However, when I export the report to an .rtf file, words get truncated on some items. What might the problem be? Thanks
  9. darkmindx

    Report Truncates Words

    There is no consistency to the number of characters displayed. Words are being truncated on some items that have less than 255. However, they are not being truncated on some items that are over 255. I'll try adding controls to the report that works and report back. Thanks
  10. darkmindx

    Report Truncates Words

    There is no difference in the two reports except that one contains number textbox (used to number the items using "Running Sum = Over All" option) case text, graphic, item question, and item answer fields, while the other one contains only the item question field. There are no other differences...
  11. darkmindx

    Report Truncates Words

    Are you sorting the report by the Item Question field? No, I'm not. Have you applied any formatting to the text box bound to the Item Question field? No, I have not. What happens if you take the above query and create a new report with just the Item Question field? Can you get it to shrink...
  12. darkmindx

    Report Truncates Words

    traingamer, The memo fields in the query are not truncated. They are only truncated in the report. dhookom, Here is the SQL statement: (Here's the SQL that is the report's record source) SELECT Test.*, TempTest.TestID FROM TempTest INNER JOIN Test ON TempTest.TempID=Test.[Item ID] WITH...
  13. darkmindx

    Report Truncates Words

    Thanks. I tried separating my query into Memo/text query and numerical query and then joined the two queries into another query. However, the finally query just had one item repeating over and over again. I don't know what happened there. I also tried to re-create my reports, to no avail. It...
  14. darkmindx

    Report Truncates Words

    It's a query. What changes when a report uses a table or when a report uses a query? Thanks
  15. darkmindx

    Report Truncates Words

    The items show up in full when I view the table which the report uses. They are only cut off in the report. In the table, the fields are Memo fields. Any other ideas? Thanks
  16. darkmindx

    Report Truncates Words

    Hi, I have a report which is linked to a table to where the user can add any items they want. I have 4 fields in the report: Case Text (Can Grow/Shrink = Yes) Graphic (Can Grow/Shrink = Yes) Item Question (Can Grow/Shrink = Yes) Item Answers (Can Grow/Shrink = Yes) The length of the fields...

Part and Inventory Search

Back
Top