Thanks, I'll give it a try. I showed it to my boss and he thought the load time was ok. I just wanted to make the form better.
I tried vbCrLf and it works for labels. Thanks again, Bryan --- In [email protected], "Jones, Glenn P MSG (Ret) FL- ARNG" <[EMAIL PROTECTED]> wrote: > 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/
