Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2015
    Posts
    1

    Question Fillable form mask

    Hello,
    I am trying to create a form like this one:
    Click image for larger version. 

Name:	Capture.PNG 
Views:	16 
Size:	8.7 KB 
ID:	20284

    Is there a way to edit my text boxes to look like this? I tried the mask option but the result isn't satisfying..



    Thank!

  2. #2
    CJ_London is online now VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    short answer is no.

    long answer is you could probably do it by having 100's of controls - the top row is 30 characters long so you would need 30 unbound controls with a colour border and white background, all next to each other. Then you would need another unbound control with a white background and no border overlaid along the top to 'cut off' the little uprights. Alternatively you could create an image of the 'background' - just screenshot what you have in your post minus the entry made.

    then, because the spacing is different from normal spacing, you would need 30 controls to overlay the above, this time with transparent border and backcolour

    finally you would need some vba code to combine the individual values together into one field. You would probably also need some code in each controls on change event to move to the next control after a character has been entered



    is it worth it?

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    Quote Originally Posted by Ajax View Post

    is it worth it?
    I wouldn't think so...but more importantly, why would you want to? This type of formatting is used on hard copy forms that are to be filled in by hand, in order to force the users to write more carefully by separating each character and spacing between words. Why would this be needed in an Access Form where the data is going to be entered through a keyboard? I can't imagine anyone entering a company name, for instance, and not placing a space between each component of the name, if that is appropriate.

    As Ajax wrote, it would take a huge number of unbound Controls, one for each possible character, a bunch of formatting, and then concatenating all the unbound Controls together!

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    I agree, this makes no sense on a digital form. Users will just have to accept that database forms do not always look EXACTLY like paper versions.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    trevor40's Avatar
    trevor40 is offline Advanced db Manager
    Windows XP Access 2003
    Join Date
    Feb 2014
    Location
    Australia
    Posts
    402
    you would have more luck using an excel's sheet cells for the boxes, hiding all grid lines and creating your own borders. but you will still need vba code behind it to put it all together.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 02-27-2015, 10:03 PM
  2. Replies: 1
    Last Post: 08-14-2014, 04:18 PM
  3. Input mask
    By scorpion99 in forum Access
    Replies: 4
    Last Post: 02-21-2014, 02:18 AM
  4. Replies: 3
    Last Post: 02-27-2013, 06:11 PM
  5. Export Data to predesigned PDF Fillable Form
    By Bisquit in forum Import/Export Data
    Replies: 1
    Last Post: 11-28-2012, 02:49 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums