Results 1 to 2 of 2
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Zero Length String Error? (A2k (9.0.4402) SR-1)

    Zero Length String Error?

    A2k (9.0.4402) SR-1

    I

  2. #2
    Lounger
    Join Date
    Jan 2001
    Location
    Pennsylvania, USA
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Zero Length String Error? (A2k (9.0.4402) SR-1)

    The Nz function converts Null strings to zero-length strings! You may want to eliminate the Nz function and let the Null value (if the field is empty) go to the table field (provided the field is not indexed and allows null values).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •