Insert Bullet Points in Memo Field

[Dwight]

My form has a Memo field that stores "To Do" descriptions. My user wants to be able to add bullet points next to their entries. There could be multiple To Do's in a single field.

Any help is appreciated.

 

[FoFa]

I think you would need a RTF type field instead of a regular text box for that.

 

[Dwight]

Thank you FoFa.

I am using Access 2002. Does it have the capability for RTF type fields?

Or will Access 2007 possibly support such a function? Lately, I've been saying "Just wait until 2007 comes out. That'll make this easy." as my standard response to user's.

 

[FoFa]

Not sure, but I think an RTF control comes with Office. It would be an external control. As to 2007, not sure.

 

[RuralGuy]

Maybe Stephan Leban's control will do. http://www.lebans.com/richtext.htm

 

[Karma]

Just wondering if this should be a seperate table i.e. 1 task has many to do's?

 

[FoFa]

Just wondering if this should be a seperate table i.e. 1 task has many to do's?

Good point, guess it depends on how you plan to use the information. Doing that you make each task complete, time taken etc. you can't do with a text field holding freeform text.

 

[AccessJunkie]

I am using Access 2002. Does it have the capability for RTF type fields?

Or will Access 2007 possibly support such a function? Lately, I've been saying "Just wait until 2007 comes out. That'll make this easy." as my standard response to user's.

Access 2007 does indeed support Rich Text Fields out of the box.

See this link for more info:
http://blogs.msdn.com/access/archive/2006/04/14/576644.aspx

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

 

[Oldsoftboss]

I have this in a memo field. Not sure how I came upon it, but when you press F5, you get a bullet!

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
On Error GoTo Err_Form_KeyDown

Select Case KeyCode

Case vbKeyF5
ClipBoard_SetText Chr(149) & Chr(32)
DoCmd.RunCommand acCmdPaste
KeyCode = 0
End Select

Exit_Form_KeyDown:
Exit Sub

Err_Form_KeyDown:
MsgBox Err.Description, , " Work Method Statements"
Resume Exit_Form_KeyDown

End Sub

 

[Oldsoftboss]

PS: Using A2002