Replies

You both guys gave me the answer I needed! Grin. While I was busy trying to describe the problem, I competely forgot to mention that the problem I was actually having was that it would fix the first paragraph but then skip the rest of the paragraphs. Now, I know I need to add “Next Para” command line. I’ll check it out via Word help files for specifics…

I have it set to Yes, still see a huge gap between two records. It is because the text field is pushing two records apart, even though it is set to Not Visible.

Brent

It works, but now I’m left with a gaping hole in middle of my report. Is it possible to somehow force the lines to “shrink” together? Right now, the experience text is set to Grow and Shrink = Yes but if there is lengthy text and it is set to Not Visible, it is still forcing lines of data apart, leaving huge gaps in the middle because the text is “still there”.

Actually, it is the condition itself that I’m having problem with. How do I put it in proper syntax? I was thinking,

If Me!txtLastTimeAttend > DatePart(YYYY) Then
txtexperience.visible=false
Else
txtexperience.visible= True

Is this correct syntax?

Sorry for not replying. I just had a baby girl and now, I’m taking couple of weeks off and today’s my last day of regular work.

I’ll get back to you as soon as I can…

Darn. I forgot to warn you that I have 4 checkboxes to deal with: ListAddress, ListHPhNbr, ListEmail and ListFax.

I have no clue how to “nest” IF statements? I wanted something like:

If Me.ListAddress = False Then
Me.txtAddress.Visible = False
Else
Me.txtAddress.Visible = True

If Me.ListHPhNbr = False Then
Me.txtHPhNbr.Visible = False
Else
Me.txtHPhNbr.Visible = True
.
.
.
End If

And I receive an error message saying that I need an End If to close If block. I can’t seem to figure out how to use ElseIf properly because if I do, then if one record wants to hide address, then it hides rest of records’ addresses because now, the control is set to Not Visible. This is bad….How do I use If…Else…ElseIf…Else?

I had tried this before giving up and posting the question. The only difference is that I didn’t include Me.xxx

What I had did was:

If ListAddress = True Then
txtAddress.Visible = True
Else txtAddress.Visible = False

What happened was ALL address fields were blank!

I guess I should have included Me.xxx

Thanks.

It’s amazing how things like this work. Today, I was planning on asking EXACT same question that was posed yesterday! This solution is EXACTLY what I needed!

That was my first thought but I was thinking, if the souvenir kept on changing each year, I wouldn’t need to store previous souvenirs, that would mean a table for single souvenir? Also, if we only offer one souvenir, how could we tell database to look at the most recent souvenir being offered?

Cripes. I had tried something similiar to this but I had tried to run it UponExit at the ComboBox and kept on getting error about cannot find subform. I didn’t think about running it ENTERING the subform! Grin.

Thanks.

No, I haven’t read Slipstick (Never knew about it)

Good news is that I finally figured out why my rules were not acting the way it was supposed to. I’m running Outlook 2002 on Exchange Server 5.5 (My company is too poor to upgrade!) and every time I create a rule, it asks me that it can only be a client side. I assumed that the rules weren’t being saved to server. HOWEVER, in a fit of anger, I deleted all rules and restarted computer and ran the Rules Wizard and got the message that said that my client and server rules were different! Even though I never had any Server side rules set up. So, I told it I wanted Client only and it resolved the problem with rule refusing to run with the Contact List because it apparently was still accessing an old rule I had created and got saved to server even though it was considered Client only! Sheesh.

Thanks to all for help. I think I have it licked.

Man! Outlook is ANNOYING! Before I posted my problem, setting up a rule that checks whether person is in my contact list (local) that is not in Global Address Book which is on the server worked fine but it kept on conflicting with another rule that checked whether that person was on Global Address Book which is on the server. After trying your suggestion, I noticed that now ALL messages that has people in my Outlook Contact list (which is local) is being completely ignored by the rule wizard! I tried deleting all rules except the one that verified that the sender is in my Contact List and it still got dumped to Spam folder. Any clues to why they are getting ignored but not the address book on server?

I just got it all figured out. My help files are still working, just that certain controls suddenly don’t have help anymore. I’m not sure why but if I can get 99% (Only two settings, I’m not seem able to get help on) of help, I’m happy.

Thanks for your suggestions.

Hand it to Microsoft to really, really muck up your computer!

Yeah, the Autocorrect is still on. But since you mentioned 2000/2002 problem as well, I guess I’ll go back to 2000 for compatibiity reason and turn off Autocorrect and see if it works.

thanks for your help.