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?
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?
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.
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
Not sure I agree with that; depends on what you mean.Tables store data, not formats.
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.
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.Not sure I agree with that; depends on what you mean.
An RTF field in a table can display font formatting.
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.
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
Thanks Bob Fitz...That may be the answer to my problem. I'll try it.
Phil H