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 sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Dlookup
or this if the previous does not work, try this: Me![City name] = DLookup("[City Name]", "City", "[Location ID] = " & "'" & Forms![Data Entry]![Location ID] & "'" ) i didn't see jbarnett put both sets of additional quotes in there. You want the string that comes out to look like this...- hoganator
- Post #7
- Forum: Microsoft: Access Forms
-
Multiple colors in Excel Cell?
OK, well what about with formatting? Can you say i want this cell to be formatted with such and such number of characters as this color, and then the rest as this color? Or, can you choose only one color per cell that way as well?- hoganator
- Post #3
- Forum: Microsoft: Office
-
Multiple colors in Excel Cell?
It is possible to select a portion of text in the formula bar and select a certain color, and then select a different portion of text in the same cell to select a different color, for example: This is the first, and this is the other part, and yet another. That can be viewed in the same cell...- hoganator
- Thread
- Replies: 3
- Forum: Microsoft: Office
