I'm attempting to pulls in a number of records through my query into a form. However I have certain predetermined values that I would like to show up a certain way. As an example every time bob shows up in a particular field it replaces it with robert.
Is there a way to write in VB code into the form something like If field1 = "bob" then field1 = "robert". If so how would I go about putting it into the vb code so that when the report opens it performs this action and displays the info that I want on the report.
Is there a way to write in VB code into the form something like If field1 = "bob" then field1 = "robert". If so how would I go about putting it into the vb code so that when the report opens it performs this action and displays the info that I want on the report.
