UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Memo Timestamp Fontsize    
 
   
rondon
post Mar 10 2017, 04:26 PM
Post#1



Posts: 5
Joined: 10-September 15



HI
I have a simple code written to timestamp new entries in a memo field, I would like to change the font size (smaller) than the users entered text. I am new to VB. I have managed to get the timestamp to work but not the font change using the code below. Any help much appreciated

Private Sub Action_AfterUpdate()
' time stamps a new entry
Me.Action = Me.Action & " " & Now()
End Sub

Thanks r4on
Go to the top of the page
 
theDBguy
post Mar 10 2017, 04:28 PM
Post#2


Access Wiki and Forums Moderator
Posts: 71,202
Joined: 19-June 07
From: SunnySandyEggo


Hi,

Welcome to UtterAccess!
welcome2UA.gif

You posted in the ASP forum. Are you doing this on a web page?

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Microsoft Access MVP | Access Website | Access Blog | Email
Go to the top of the page
 
rondon
post Mar 10 2017, 06:17 PM
Post#3



Posts: 5
Joined: 10-September 15



No sorry Access DB must have selected the wrong forum sorry
Go to the top of the page
 
theDBguy
post Mar 10 2017, 07:17 PM
Post#4


Access Wiki and Forums Moderator
Posts: 71,202
Joined: 19-June 07
From: SunnySandyEggo


Okay, so are you trying to change the font in the table or a form. Please keep in mind tables only store data. It doesn't care about how the data is formatted. Formatting usually only applies to "displaying" the data - not storing it.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Microsoft Access MVP | Access Website | Access Blog | Email
Go to the top of the page
 
rondon
post Mar 11 2017, 12:35 AM
Post#5



Posts: 5
Joined: 10-September 15



Just the Form, I have a bigger font set for the text to aid the user in reading it (Visual impaired) but I don't want the timestamp as big as it clutters the memo field
Go to the top of the page
 
theDBguy
post Mar 11 2017, 12:10 PM
Post#6


Access Wiki and Forums Moderator
Posts: 71,202
Joined: 19-June 07
From: SunnySandyEggo


Hi,

I think I understand it now. You're trying to change the font of only some parts of the data in the memo field. To do so, your Memo field has to be set to use Rich Text Formatting. Do you know if your Memo field is formatted as Rich Text? If so, you could try adding some HTML tags to your code. I don't recall if CSS will work, so you might stick with pure HTML tags for now such as <font>.

Hope it helps...

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Microsoft Access MVP | Access Website | Access Blog | Email
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    11th December 2017 - 09:42 PM