Professional Web Applications Themes

Partial Default Value? - Microsoft Access

I have a form field in which the input is always a six- digit number preceeded by the letter "P". What is the proper expression for setting the default value so that the "P" appears with the insertion point behind it (so that when I tab to this field I can just type the number without having to type the letter repeatedly). This seems like it should be a no-brainer (what can I say?)....

  1. #1

    Default Partial Default Value?

    I have a form field in which the input is always a six-
    digit number preceeded by the letter "P". What is the
    proper expression for setting the default value so that
    the "P" appears with the insertion point behind it (so
    that when I tab to this field I can just type the number
    without having to type the letter repeatedly).

    This seems like it should be a no-brainer (what can I
    say?).

    Charlie Guest

  2. #2

    Default Partial Default Value?

    In the AfterUpdate event of the field in question put the
    following code

    txtField.value = txtField.value + "P"
    if you want "P" to prefix the value switch the places.

    HTH
    vb 
    vb Guest

  3. #3

    Default Partial Default Value?

    Thanks!
     
    >.
    >[/ref]
    Charlie Guest

Similar Threads

  1. Partial Transparency
    By Ilya Razmanov in forum Adobe Illustrator Windows
    Replies: 10
    Last Post: May 27th, 07:33 AM
  2. Partial Borders
    By David Lally in forum Adobe Photoshop Elements
    Replies: 1
    Last Post: August 30th, 06:42 PM
  3. Put partial text
    By Alvin Bakker in forum Macromedia Director Lingo
    Replies: 1
    Last Post: August 5th, 12:59 PM
  4. Partial Index
    By Maggy in forum Microsoft SQL / MS SQL Server
    Replies: 3
    Last Post: July 2nd, 01:29 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139