[Webinar] Streamline your web hosting managementRegister Today

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 256
  • Last Modified:

Control Source is Null

My form is based on a query. In my table it is possible to have a field blank, in this case UserID.
When I find a record where the field UserID is blank I would like to display, in red, bold "NO USER!" in the bound control where USERID is. Other data could still exist in other fields.
Frank Freese
Frank Freese
1 Solution
Rey Obrero (Capricorn1)Commented:
in your query instead of using UserID, try this

IIf([UserId] is Null,"NO USER",[UserID])

and as for the BOld effect, use conditional formatting
Frank FreeseAuthor Commented:
again, thanks

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now