Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Sunrise, Florida
    Posts
    324
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Rules (maybe?) (Word 2K)

    Well

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Rules (maybe?) (Word 2K)

    And I thought I was bad! Wait 'til my department hears about this guy. <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15> Anyway:

    1. No, but you could create a macro to scrub the cell that you could invoke with a keystroke, or a macro to scrub all cells in the table in one go after you've finished filling it in. There are any number of approaches to this, but unless you change the form completely to use form fields, there's no convenient way to trigger a macro when tabbing out of a table. (Yes, you could attach a macro to the Tab key itself, but this seems like more trouble than it's worth.)

    2. Maybe use two different AutoText or AutoCorrect entries for this (e.g., bpg "(Page n)" and epg " (Page n)")?

    Hope this helps. This and a couple ibuprofen. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

  3. #3
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Putnam Valley, New York, USA
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rules (maybe?) (Word 2K)

    A not-so-elegant solution to remind folks that the date needs to be in a particular format is to

    Throw in a dummy date in the proper format, and explain to users they should simply type over the proper date in that format

    Include in the document some instructions manually inserted. The instructions should be formatted as "hidden" text, so that it doesn't print out. Doesn't work well if the TOOLS, OPTIONS, VIEW isn't set to show hidden text.

    Select the cell and INSERT a comment that says something like "Only use the date format M/D/YY"

    I'm not up on my VBA but there is a field that is entitled MACROBUTTON. I've only ever used it as
    MACROBUTTON nomacro displaytext
    Macrobutton allows a macro to be run when the user clicks on it in the document. The nomacro argument means that there isn't any macro running, but allows me to put in some "dummy text" which, because I have TOOLS OPTIONS VIEW set to display fields in shading, shows up dramatically to remind me that I need to pay particular attention there.

    I've included a tiny sample.
    Attached Files Attached Files

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Sunrise, Florida
    Posts
    324
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rules (maybe?) (Word 2K)

    I want to thank everyone for their help. I'm working on a solution that will implement a combination of your ideas. Thanks again!!!

  5. #5
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rules (maybe?) (Word 2K)

    Hi Roberto:
    Can't do exactly what you want, but:

    For #1, you can run two Find/Replace procedures. Actually, you could put them in a macro & run it once. This assumes that you only have dates in a similar format & it won't work if dates are like 06-18-03.

    Using Wildcards:
    Find: 0([1-9]/[0-9]{2})
    Replace: 1

    Run this twice & it should change the dates whose format is MM/DD/YY to M/D/YY.

    2. For the second issue, I'm not sure of your exact format. You could create formatted Autotext entries that say:
    Background<sp>
    Evidence<sp><sp>
    where <sp> is a real space.

    Then you could enter them & start typing. Alternatively, you would need to use a protected form that can control formatting, including date formatting.
    Cheers,

Posting Permissions

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