I tried this on both, before and after update; but it doesn't work on
pasted
text from say an HTML page... I'm using Access 2007.
Private Sub Start_Note_BeforeUpdate(Cancel As Integer)
Me.Start_Note.FontName = "Arial"
Me.Start_Note.FontSize = 10
End Sub
Private Sub Start_Note_AfterUpdate()
Me.Start_Note.FontName = "Arial"
Me.Start_Note.FontSize = 10
End Sub
"AndrewOfAzotus" wrote:
> OK, this works in 2k3:
>
> Private Sub ResText_BeforeUpdate(Cancel As Integer)
> Me.<FieldName>.FontName = "Arial"
> Me.<FieldName>.FontSize = 24
> End Sub
>
> although a fontsize of 24 is a little big :-)
>
> Andrew/
>
> "efandango" wrote:
>
> > Andrew,
> >
> > I'm using Access 2007, and it doesn't fo it for me, perhaps it's
because i'm
> > using the rich text for the Text Format default setting. How would I
use the
> > afterupdate reset font, do you have a code example?
> >
> >
> >
> > "AndrewOfAzotus" wrote:
> >
> > > For me, (access 2k3) text pasted into a memo field does take on the
memo
> > > field font.
> > >
> > > In any case, can't you use the after_update event and just reset the
font
> > >
> > > Andrew/
> > >
> > > "efandango" wrote:
> > >
> > > > Crystal,
> > > >
> > > > thanks for the notepad tip. I was rather hoping there was some
type of
> > > > switch or code that would just convert any text pasted into a
specified font
> > > > & size. It always amazes me how the blindingly obvious escapes the
attention
> > > > of Microsoft's testing and usability people...
> > > >
> > > > I may look at Allen Browne's suggestion too (thanks Allan).
> > > >
> > > >
> > > >
> > > > "strive4peace" wrote:
> > > >
> > > > > Hi Eric,
> > > > >
> > > > > paste into NotePad first -- then copy and paste from NotePad...
> > > > >
> > > > > unless you are using a rich text control, however, it should not
make a
> > > > > difference...
> > > > >
> > > > > Warm Regards,
> > > > > Crystal
> > > > >
> > > > > remote programming and training
> > > > >
> > > > > Access Basics
> > > > > 8-part free tutorial that covers essentials in Access
> > > > > http://www.AccessMVP.com/strive4peace
> > > > >
> > > > > *
> > > > > (: have an awesome day :)
> > > > > *
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > efandango wrote:
> > > > > > Is there a way of making any text that I paste into a memo
field conform to
> > > > > > one font style and size? Arial 9pt, for example.
> > > > > >
> > > > > > I cut and paste text from all kinds of sources and find that
the pasted text
> > > > > > comes in with the original source font style and size.
> > > > >
|
