Results 1 to 8 of 8
  1. #1
    Phil H is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Dec 2019
    Location
    Phoenix, AZ
    Posts
    19

    Bold type does not transfer from Form

    I have fields defined in a form as Bold, and they display bold in the form. However, the bold does not carry over to either table or report. What am I missing here?

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    you are missing the fact that Bold/Italic etc are formats, not data. Tables store data, not formats.

    The only way you can store a format of this type is within the data. And the only datatype that will do this is rich Text (known as long text in later versions of Access) which will store the formatting code as html within your value. Note if your controls have already been created, you will need to change their text format property (data properties) to rich text

    Note that data in tables should be kept as unformatted as possible so you know exactly what you have - primarily relevant to dates and decimal type numbers.

  3. #3
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    You would need to set the control(text box) used in the report to bold.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  4. #4
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Tables store data, not formats.
    Not sure I agree with that; depends on what you mean.

    An RTF field in a table can display font formatting. Is it storing the format? I'd say so, by way of rtf tags, which you don't see but they are there. If you use a function like Left on an rtf field, you will find that the function counts the rtf characters. I agree that there is no point in worrying about formats in table fields. To do so implies that users are looking directly at tables, which they should not be.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  5. #5
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    Not sure I agree with that; depends on what you mean.

    An RTF field in a table can display font formatting.
    I did explain that - point is the formats are stored within the data, not as a property of the field - so you cannot set a format for a field (other than date/numeric formats). And using rtf means if you want a field to be bold, you have to set it for each and every entry in the field which I don't believe the OP wants.

  6. #6
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    OK, be fair now. You said Tables store data, not formats. You didn't say anything about properties. I simply meant that the formatting is stored with the data - as rtf elements.
    Since the OP has a form that displays field formatting, it should be a given that this is going to be applied to every record in those fields. I don't see anything about the post that suggests the formatting was supposed to be applied to the field per se.

  7. #7
    Phil H is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Dec 2019
    Location
    Phoenix, AZ
    Posts
    19
    Thanks Ajax...I get it. I certainly don't want to get involved in rich text and all that in my table. Reply from Bob Fitz may solve my real problem, which is to get bold type in report.
    Phil H

  8. #8
    Phil H is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Dec 2019
    Location
    Phoenix, AZ
    Posts
    19
    Thanks Bob Fitz...That may be the answer to my problem. I'll try it.
    Phil H

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

Similar Threads

  1. Transfer Form name to subform
    By jscalem in forum Access
    Replies: 6
    Last Post: 03-15-2019, 03:16 PM
  2. Transfer data from one form to another
    By sparker75 in forum Macros
    Replies: 1
    Last Post: 09-07-2018, 03:25 PM
  3. Replies: 3
    Last Post: 04-01-2013, 01:43 PM
  4. Bold field
    By devcon in forum Reports
    Replies: 1
    Last Post: 09-23-2011, 10:32 AM
  5. Bold Cells
    By jcsports31 in forum Access
    Replies: 12
    Last Post: 09-10-2010, 12:15 PM

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