In Access, the * is a wildcard character. That means it represents any
number of characters. So in Access, if you wanted to run a query for
all names that start with Smi and end with an n, your Like statement
would be Like "Smi*n". Your results would give you names like
Smithson, Smitton, but not Smith. The % is also a wildcard character,
but not when used in Access. If you take your statement,
rst3!msglog_text Like "'%Abnormal%'", the only time the code in your If
statement will be executed is when rst3!msglog_text = '%Abnormal%'. In
Access, the % is treated like an ordinary character. You would use the
% as a wildcard if you were, for example, running a pass through query
to a SQL Server.
By the way, the statement after your IF...Then does not make sense.
You would not use Like in that fashion.
Hope that helps!