Search results for query: *

Perhaps a Ctrl+M on the line may help? It should insert a return where you need it.

OK I'm a newbie but the syntax for an IIf is IIf not Iif. I've found Microsoft is pretty unforgiving when it come to syntax. =Trim(IIf(IsNull([LName]),[Business]," ")) The Trim function simply removes preceding spaces =IIf(IsNull([LName]),[Business]," ") That should work

I believe I have the same trouble. My system at the house is running Windows 98 and everything works fine there but when I take it to the shop and attempt to run my database on a Windows 2000 machine none of the IIf functions work. Both machines have the same version of Access installed. What...

I tried your suggestion and it worked on the form. Unfortunately, it doesn't seem to update the table. So I am back to attempting to write a macro. I know this should be stupid simple but nothing I have tried has worked. There is another problem I would like it to check for data in another field...

I'm trying to get Access to look at a field, compare it to a text if the field is a certain text value then update another field with the output I want. I think the problem is in my syntax but my knowledge base is very limited. I am trying to do this using a macro (set value command)...