Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Sep 2009
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I would like to automatically generate a Bar code based on the value of a field in Access. Is there a routine for this built into Access or third party add on? Thank you for your help

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    It could depend on the bar code you are using. 3 of 9, for example, can be downloaded as a font. You then create a field based on what you want bar coded. 3 of 9 uses a start and stop character of *. An example of your field would be

    ="*" & [PartNumber] & "*"

  3. #3
    New Lounger
    Join Date
    Sep 2009
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='KevinOVF' post='793397' date='15-Sep-2009 11:58']I would like to automatically generate a Bar code based on the value of a field in Access. Is there a routine for this built into Access or third party add on? Thank you for your help[/quote]

  4. #4
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts
    [quote name='KevinOVF' post='793397' date='15-Sep-2009 11:58']I would like to automatically generate a Bar code based on the value of a field in Access. Is there a routine for this built into Access or third party add on? Thank you for your help[/quote]
    As mbarron mentioned, you can use a 3 of 9 barcode font that you can easily find for free on the internet. This is the easiest way to go if all you need is a simple barcode (I've used it alot). There are some 3rd party controls available if you really need to get fancy (rotating the control, different barcodes, custom sizes, etc.).
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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