Connecting Tech Pros Worldwide Help | Site Map

Access 2007 and rich text

 
LinkBack Thread Tools Search this Thread
  #1  
Old May 28th, 2007, 05:35 PM
ARC
Guest
 
Posts: n/a
Default Access 2007 and rich text

Just found out something interesting with Access 2007... In table design, if
you set a memo field to the new rich text option, and put that control on a
form, set the control to rich text, you can only use the text formatting
menus IF the control is on a parent form! If the control is placed on a form
that is a subform, the mini format toolbar, and the access toolbar will not
work!

However, if you place the control on a self-contained form / popup form,
then mini formatting menu will open after you highlight rich text.

Ok, Access 2007 will be some major re-design work. My existing app uses a
mainmenu, that contains a submenu, and I load all the various screens into
the submenu. I'll have to scrap that, and have each screen be a
self-contained form.

Interesting stuff...



  #2  
Old May 29th, 2007, 09:25 AM
Allen Browne
Guest
 
Posts: n/a
Default Re: Access 2007 and rich text

You're right. The mini-toolbar and the ribbon items for handling rich text
don't work for a rich text control in a subform.

You probably don't want to spell-check a rich-text field either: it can make
a right mess of your data (e.g. if it contains a carriage return.)

More info about these items:
http://allenbrowne.com/Access2007.html#Bugs

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"ARC" <andy@andyc.comwrote in message
news:kgE6i.2604$5j1.54@newssvr21.news.prodigy.net. ..
Quote:
Just found out something interesting with Access 2007... In table design,
if you set a memo field to the new rich text option, and put that control
on a form, set the control to rich text, you can only use the text
formatting menus IF the control is on a parent form! If the control is
placed on a form that is a subform, the mini format toolbar, and the
access toolbar will not work!
>
However, if you place the control on a self-contained form / popup form,
then mini formatting menu will open after you highlight rich text.
>
Ok, Access 2007 will be some major re-design work. My existing app uses a
mainmenu, that contains a submenu, and I load all the various screens into
the submenu. I'll have to scrap that, and have each screen be a
self-contained form.
>
Interesting stuff...
  #3  
Old May 29th, 2007, 03:55 PM
ARC
Guest
 
Posts: n/a
Default Re: Access 2007 and rich text

I just read your list, Allen, and I'm sure glad I was never in the habbit of
using <Shift><Delete>!! That could be very bad...

Andy


  #4  
Old May 29th, 2007, 04:05 PM
ARC
Guest
 
Posts: n/a
Default Re: Access 2007 and rich text

Also, I've noticed the built in date picker won't show for an unbound
control...Not sure about a datasheet control yet, but I'm betting it won't
show..


  #5  
Old May 30th, 2007, 12:45 PM
Allen Browne
Guest
 
Posts: n/a
Default Re: Access 2007 and rich text

Does it make any difference if you set the Format property of the unbound
control to Short Date? That's usually enough to give Access a clue about the
intended data type.

Also, make sure there's nothing in the Input Mask.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"ARC" <andy@andyc.comwrote in message
news:42Y6i.10170$2v1.7599@newssvr14.news.prodigy.n et...
Quote:
Also, I've noticed the built in date picker won't show for an unbound
control...Not sure about a datasheet control yet, but I'm betting it won't
show..
  #6  
Old May 30th, 2007, 02:15 PM
ARC
Guest
 
Posts: n/a
Default Re: Access 2007 and rich text

Thanks for that.. There was something in the input mask...


"Allen Browne" <AllenBrowne@SeeSig.Invalidwrote in message
news:465d6e9a$0$17973$5a62ac22@per-qv1-newsreader-01.iinet.net.au...
Quote:
Does it make any difference if you set the Format property of the unbound
control to Short Date? That's usually enough to give Access a clue about
the intended data type.
>
Also, make sure there's nothing in the Input Mask.
>
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
>
"ARC" <andy@andyc.comwrote in message
news:42Y6i.10170$2v1.7599@newssvr14.news.prodigy.n et...
Quote:
>Also, I've noticed the built in date picker won't show for an unbound
>control...Not sure about a datasheet control yet, but I'm betting it
>won't show..
>

 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 220,840 network members.