Testing for a blank string control value using vb

I

Isis

I want to carry out some field edits based on the value of another string
field - I can not seem to test it for having no value using;

If [Field] = "" - does not fire if field is blank

If [Field].Text = "" - does not fire if field is blank

Obviously not doing the right thing - any help appreciated.

Is it possible to compare the contents of String and Numeric fields ?


Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Syntax problem with [FieldNames] 1
Putting the value of an Integer into a String ? 2
MS Outlook VBA- editing an empty value of a task item 0
problem with date in the VBA macro 0
Default Field Value 3
how do i set a field to be the same value as the previous record 14
Using a check box to set the value of a string variable 4
Testing a string againsts a list of strings 2

Top