Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using Code to Make items Bold, Italic, etc

Status
Not open for further replies.

pbrown2

Technical User
Jun 23, 2003
322
US
Currently below is the code that is being used to "SendObject". However, along with using vbTab, ect, I would like to have [Password] to be sent in BOLD. Any ideas??

Private Sub SaveMe_Click()
If Me.Plant <> &quot;EXEC&quot; Then
DoCmd.SendObject , , , [UserID], , , &quot;Capital Budget Password&quot;, &quot;Your Password is: &quot; & [ReviewPassword] & &quot; &quot; & vbCr & &quot; &quot; & vbCr & &quot; &quot; & vbTab & &quot;This password will allow you to enter the Review area of the Budget. From this area you are able to add new, modify or delete items and view multiple reports. &quot; & vbCr & &quot; Also, if you execute any of the enginering combination reports, the password is: &quot; & [SmyrnaEngineering] & &quot;&quot;, False
'DoCmd.SendObject , , , [UserID], , , &quot;Capital Budget Password&quot;, &quot;Your Password is: &quot; & [ReviewPassword] & &quot; This password will allow you to enter the Review area of the Budget. From this area you are able to add new, modify or delete items and view multiple reports. Also, if you execute any of the enginering combination reports, the password is: &quot; & [SmyrnaEngineering] & &quot;&quot;, False
Emailsent.SetFocus
[Emailsent] = True
DoCmd.Close
Else
DoCmd.SendObject , , , [UserID], , , &quot;Capital Budget Password&quot;, &quot;Your Password is: &quot; & [ReviewPassword] & &quot; &quot; & vbCr & &quot; &quot; & vbCr & &quot; &quot; & vbTab & &quot;With the exception of locking the budget for review, this password will grant you access to every secured portion of the database. &quot; & vbCr & &quot; &quot; & vbCr & &quot; To lock or unlock the database for review, use the password: &quot; & [LockDBPassword] & &quot; &quot; & vbCr & &quot; &quot; & vbCr & &quot; &quot; & vbTab & &quot; To lock, click on the Logo on the entrance screen. To unlock, click on the Unlock button located on the Review screen&quot;, False
[Emailsent] = True
DoCmd.Close

End If


End Sub




Thank you for any and all help,

PBrown
 
PBrown,

You can attempt to use the following, but I am not certain if the formatting in Access will translate into Outlook for you.

Me.[Password].FontBold = True

HTH,

Steve
 
You might also take a look at this thread thread702-396121

That has alot of good info for send e-mail from Access. I did a search on the thread and found some code for having bold font.

Hope it helps

Dave
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top