Search results for query: *

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

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

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...

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

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

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...

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.

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

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

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...

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...

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...

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...

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

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

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...