Results 1 to 3 of 3
  1. #1
    JuanGmo is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2020
    Posts
    4

    How do I concatenate two fields getting the result with different fonts?

    I require to prepare a report with scientific names where different font types or colors are used in the resulting combination, example:

    Homo sapiens, Linnaeus (The scientific name: Homo sapiens must be italic. Linnaeus the author of the scientific name is not italic).

    Homo sapiens, Linnaeus, or in this case Linnaeus also have another color.



    Thanks a lot if You can help me, Juan

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    you need to use a memo field (long text) and set the text type to richtext

    rich text uses html type coding to set font, style, colour etc

    see this link for an example db where you can set your fonts etc then see the code
    https://www.access-programmers.co.uk...ne-etc.290820/

    so for example

    hello world

    would be

    Code:
    <font color=red>hello</font> world
    so you might concatenate your two words together

    Code:
    "<i>" & me.sciencename & "</i>,<font color=red>" & me.author & "</font>"

  3. #3
    JuanGmo is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2020
    Posts
    4
    Hi Ajax, thanks a lot, I will study and try and let You now if I get it, Saludos, Juan

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

Similar Threads

  1. Concatenate Like Fields
    By Dean0_53 in forum Queries
    Replies: 5
    Last Post: 12-14-2018, 06:45 AM
  2. How to concatenate 3 fields?
    By nicoboss in forum Access
    Replies: 9
    Last Post: 11-22-2017, 11:04 AM
  3. How to concatenate fields
    By aparnawangu in forum Access
    Replies: 1
    Last Post: 10-28-2015, 01:03 AM
  4. Concatenate two fields
    By buckwheat in forum Access
    Replies: 8
    Last Post: 06-28-2013, 07:06 AM
  5. Concatenate Fields
    By Njliven in forum Forms
    Replies: 9
    Last Post: 12-21-2012, 08:31 AM

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