12345678 Values Being Displayed
I have a field set to screen data but with VB Scripting that shows the following:
value = Field("variable1") + " " + Field("variable2") + "Text1 " + Field("variables3") + " Text2"
The "variables" come from a text file.
In Bartender, while editing the label, the above code is shown as:
12345678 12345678 Text1 12345678 Text2
When I print the label it will display my information from my text file fine.
What can I add to my label format to have it display a better sample value while editing the label, instead of the 12345678 error? I would prefer to not have multiple screen data or database field text objects, as it makes it harder to line up the text boxes, fonts, etc. If it is all on one line that works very well for my purposes.
Thank you for your assistance.
-
If you use an "Event Control Script" Visual Basic Script type of script, then you can add the desired "Sample Value" into the "OnAutoSelectedEvent" event.
Otherwise, you can use "Embedded Data" as your source, write your desired "Sample Value" under "Embedded Data" field, then select the "Transforms" tab and use VBScripting "OnProcessData" from there.
0 -
Legacy Poster
★ BarTender Hero ★
Thank you for your reply. How do I use 'Embedded Data' as my source? Did this replace 'Screen Data' in more recent versions of Bartender? Unfortunately, I am using version 9.01. No matter what I put in the Sample Value field, it shows as the '12345678' on the screen during editing, but will print properly.
0 -
Yes, "Embedded Data" source replaced "Screen Data" source.
What about trying directly "VBScript", "Event Control Scripts" as your data source, will it then work?
0 -
Legacy Poster
★ BarTender Hero ★
Following your suggestion, I tried VBScript/Event Control Scripts as a source, and I got the same result. (Perhaps I wasn't doing it correctly).
My data is called from a text file, could that be part of the issue?
Do you think this issue would be remedied with the new version of Bartender?
Thank you for your assistance.
0 -
On the bottom part of your label design area, you should see a "database bar" with a "connect to database" icon. If you click on this button / icon, does the result change? Otherwise, please attach a sample BT document and sample database text file.
0 -
Legacy Poster
★ BarTender Hero ★
Thank you for your reply. I attached a sample BT file to show you what I am experiencing. I also including a sample text file. On the screen you see the "12345678 12345678 12345678 12345678" when the sample data is "100 200 300 400". This is also what the VB script is programmed to show. And the label will print the information correctly.
I am using BT version 9.01. I would like for either the programmed data or the sample data to display on the screen so it is easier to design the label.
Perhaps if I had a newer version of Bartender this would work better?
Thank you again for your assistance.
0 -
I've attached a modified BarTender document which uses 4 different data sources (rather than just one), each one for each database field. The "Sample Data" for each field will be displayed in BarTender.
In newer versions of BarTender you will find a "Database Field" Live content at BarTender document design time, which is the exact feature you're looking for.
0 -
Legacy Poster
★ BarTender Hero ★
Thank you for your help and the file you included. Can you also include the text file you created?
It looks like no VB script was used either. I cannot find any in the label, unless I am looking in the wrong place.
Thank you again for your assistance. It looks like I will have to push for an update to our Bartender software.
0 -
That's correct, no VBScript was created because it isn't needed (at least not for just showing the content of a few database fields on the same text object). The text file is the same as yours, you just need to reconnect to it as I placed the text file on a different folder than you. Do this by accessing the "File > Database Connection Setup" dialog, select the "Options" tab on the right and now choose the proper path for your "Text File Name".
0
Please sign in to leave a comment.
Comments
9 comments