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!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dwyerj

    Hide blank field and remove formatted period and space when blank

    Thanks Straybullet for helping me however access kept saying there is a syntax error. I copied and pasted it directly in as you had typed. Traingamer's solution seems to work fine. Thank you both for helping me.
  2. dwyerj

    Hide blank field and remove formatted period and space when blank

    My delima is that I need to have [MI] and I need to have a period after the [MI] but not all names have middle initials. I know this is probably a simple IIF statement but I am not sure how to set it up so that if the field is null that it removes the period and the blank space created when...

Part and Inventory Search

Back
Top