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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Problem concerning continuous forms.
Peter, I would be greatly indebted if you'd send me the same. My current project has the same problem. Access 2000 TIA... Boyd boydweiger@bigfoot.com- BoydW
- Post #9
- Forum: Microsoft: Access Other topics
-
Changing field text color or background color based on field value
Use Conditional Formatting. Select the field then from the menus go: Format|Conditional Formatting That'll do it no problem. -Boyd- BoydW
- Post #2
- Forum: Microsoft: Access Other topics
-
setting control source from possible null field
I would use an IIF function to test for the contents of the text boxes. If both are blank, then return "", if one is blank, only DSUM the other one, if neither one is blank, DSUM both.- BoydW
- Post #2
- Forum: Microsoft: Access Other topics
-
Syntax for a DLOOKUP as the criteria of another DLOOKUP?
Can a DLOOKUP function which returns a string be the criteria for a DLOOKUP? Here's my example I'm working with now: -Text box Name: OPO_SSN Control Source: =DLookUp("[SSN]","NTT Staff","[Dept]='OPO'") -Another Text box Control Source: =DLookUp("...- BoydW
- Thread
- Replies: 1
- Forum: Microsoft: Access Other topics
