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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
OnPrint Event executes only after all data is formatted
I have a report that needs to determine a set of criteria for each record prior to printing the detail line. In the OnFormat event, I test each record in the recordset. If it doesn't meet the criteria, I set the following properties. With Me .MoveLayout = False .NextRecord = True...- RandyJ
- Thread
- Replies: 3
- Forum: Microsoft: Access Reports
-
String variable only storing 256 characters.
Good Afternoon, I'm trying to store a long string into a string variable, but it seems to only retain around 256 characters. In looking at the Access VB reference regarding String Data Types, it suggests that this data type will hold up to 64,000 characters. Am I misunderstanding? I've also...- RandyJ
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
-
"Word is calculating the word count" message for Properties
Good Day, I've experienced this problem in the past but it's not been critical since my documents were small. But now that I'm working on larger documents, it's become a problem. I've written a script to set several BuiltInDocumentProperity fields. When I run the script it recalculates the...- RandyJ
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
