>>>>Hi! I need to give my users the ability to create labels. They should be able to select a standard Avery format and then choose which fields to print from a list I provide. Has anyone done this? Can I do this without having to create a template for each of the 75+ available formats? I have unsophisticated users who need a very simple interface.
>>>>
>>>>Thanks
>>>>Elyse
>>>
>>>Elyse,
>>>
>>>You can include CREATE LABEL in your application to allow users access to the VFP label creation functionality.
>>>
>>>HTH,
>>>
>>>George
>>
>>I don't think my users can handle VFP's Label Designer. I can't let them choose fields on their own. Any other suggestions?
>>
>>Elyse
>
>I don't think that I have any that you'll like, because I don't really think there are any. Nevertheless, here goes and I'm going to include that I can think of:
>
>1. Third party product. Advantages: Quick implementation. Drawbacks: Additional cost, training, and you'll have to provide some support. Additionally, I don't know how, other than using SET FIELDS TO, you would be able to limit access. Further, whether or not the product would respect your setting isn't known.
>
>2. Reinvent the Wheel, or in this case, the Label Designer. Advantages: You would have total control of the design process. Drawbacks: You'll have to thoroughly familiarize yourself with the meaning of each of the fields (and the appropriate values) in the LBX table, which could be a very time consuming proposition.. Additionally, you'll still have to train and support.
>
>3. The Label Designer (sorry). Advantages: Little overhead in terms of development or additional code to support. You can control the access to the fields using SET FIELDS (same as #1). You should be already familar with it, so the support issue can be minimized. Drawbacks: The interface isn't exactly inuitive, which meaning you'll have to train the users.
>
>Of these three, it still looks (to me) like CREATE LABEL is the best choice. You know your users far better than I, so in your case, perhaps not. Maybe someone else here might care to comment.
>
>George

I would consider manipulating the LBX on my own if I had a little more info. I have a copy of the .LBX Table Structure fro VFP 5 so I can more or less figure out what the fields are for. Does anyone know what the values for "OBJCODE" mean? Also, does anyone know how to parse out the numbers in the DATA field of the LABELS.DBF so I can fill the appropriate fields in the LBX file (height, width,margins,etc.)? I would need to create an LBX file for any Avery format. Thanks for any help!

Elyse