• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Concatenate keeping source font

k1s

Member
Hi I've got a table with around 600 bar codes in column [Barcode] (formatted using "Code 128" font) corresponding to a part number in column [Part Number].

I'd like to be able to print them all with the part number under the barcode and so need to find a way to concatenate with a line return / char(10), while keeping the font, in a new column in the table.

Could this be done using a user defined function =keepformat([@[Barcode]]) & CHAR(10) & keepformat([@[Part Number]])?

Any help greatly appreciated.
 
Back
Top