Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jan 2006
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Replace Number with Text (Office 2003)

    Sorry for a potentially basic question. I have a table with a field named Scale1 that will have a number 0-4 in it. If the number is 0 or blank, I would like it to say "BULK" instead of 0 or blank. How can I do this?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Replace Number with Text (Office 2003)

    You can set the Format property of the field (or of the text box bound to the field on a form or report) to the following:
    <code>
    0;;"BULK";"BULK"
    </code>
    The Format property for number fields can have up to 4 sections, separated by semi-colons.
    The first is for positive numbers.
    The second is for negative numbers; if omitted, the same format as for positive numbers is used.
    The third section is for 0 (zero) values.
    The fourth section is for null (blank) values.

  3. #3
    New Lounger
    Join Date
    Jan 2006
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Replace Number with Text (Office 2003)

    Thank you very much for your help. It worked perfectly.

Posting Permissions

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