Hi Bryan, You may try "On Activate". On the label try vbCRLF (carriage return, line feed)
Glenn P. Jones IHS -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of stomper57 Sent: Friday, 23 September, 2005 3:56 PM To: [email protected] Subject: [AccessDevelopers] Pop Up Form Hi, I'm trying to create a pop up form that validates data before a report is created. If the data entry is ok, the report will load and the form will close. If there were errors, I created a function that describes where the errors are and gives the user the ability to cancel the report. My problem is the speed of the form opening. I would like the form to open fast and then do all of the calculations. I've tried OnOpen and OnLoad events and the form and takes 40 seconds to open. I've thought about a Timer event, but I need this to be calculated once not every xxxx milliseconds. Another issue, I'm using a label's caption to describe the errors. vbCr works great in a MsgBox for a carriage return, but in a text box or a label it doesn't work. How do I create a carriage return on a label? Thanks, Bryan Please zip all files prior to uploading to Files section. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
