still have the problem then I'd suggest the following:
Len(Trim([address] & " ")) > 33
The addition of the " " is to prevent the Trim
function from crapping out if the value of [address]
is Null.
--- "Jacobs, Martien" <[EMAIL PROTECTED]> wrote:
> The result of the Len function is a numeric value.
> Use Len([adress]) > 33 rather then Len([adress]) >
> "33"
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
SPONSORED LINKS
| Microsoft access database | Database development software | Microsoft access development |
| Database management software | Inventory database software | Membership database software |
YAHOO! GROUPS LINKS
- Visit your group "AccessVBACentral" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
