Categories

Main
Database
Java
Microsoft.NET
Adabas
DB2
Informix
Microsoft SQL Server
MySQL
Oracle
Pervasive.SQL
PostgreSQL
Sybase
Other
ASP
ColdFusion
Crystal Reports
Delphi, C etc
JAVA
Microsoft.NET
Perl and the DBI
PHP
ANSI SQL
Unix Shell Scripts
Visual Basic
XML & XSLT
Corel Paradox
FileMaker
Microsoft Access
Microsoft Excel
Other PC Databases
Applications & Tools
Database Concepts & Design
EJB programming & troubleshooting
EJB design
General J2EE
XML & Web services
Web tier: servlets, JSP, Web frameworks
Performance and scalability
Industry news
TSS feedback
Mobicents Contributors
Mobicents Users
JSLEE Resource Adaptor Types
Planning JavaOne 2008
Sun Tech Days
Other Java conferences
Binary Web Services and XML
Metro and JAXB
GlassFish
GlassFish Plugins
Project jMaki
GlassFish WebTier
Mural
Java Development Tools
Java WS & XML Community News
JAXP
Java SE
6uN Early Access
Java Quick Starter
Java SE Snapshots: Project Feedback
JCK Forum
Feedback and Suggestions
JDK Distros
JDK Open Source
General JSR Discussion
JCP 2.6
JXTA Community Forum
ME Interest
ME Cool Apps
ME General Help
ME Feedback & Suggestions
ME Application Developer Interest
Blu-ray Disc Java
ME Developer Days
Squawk
Mobile Developer Alliance
OpenCable
LWUIT
JavaFX Script Language Discussion
OpenJFX General Discussion
Scene Graph
General Performance Discussion
Your Java Career
NetBeans 6.0
Servlets
JSP
JSF
Portals and Portlets
EJB and Other Java EE Technologies
Distributed Java
Object Relational Mapping
JDBC
Web Services
Swing / AWT / SWT / JFace
JNLP and Web Start
Java Micro Edition
Sockets and Internet Protocols
Threads and Synchronization
Performance
Applets
I/O and Streams
Other Java APIs
Game Development
Java in General (beginner)
Java in General (intermediate)
Java in General (advanced)
Programmer Certification (SCJP)
Developer Certification (SCJD)
Associate Certification (SCJA)
Web Component Certification (SCWCD)
EJB Certification (SCBCD)
Mobile Application Certification (SCMAD)
Architect Certification (SCEA)
Web Services Certification (SCDJWS)
XML Certification
Product and Other Certifications
Mock Exam Errata
Sun Certification Results
Authors' Corral
Book Reviews
Events
Bunkhouse Porch
Teachers' Lounge
Testing
OO, Patterns, UML and Refactoring
IDEs, Version Control and other tools
Ant, Maven and Other Build Tools
Linux / UNIX
Mac OS
HTML and JavaScript
XML and Related Technologies
Agile and Other Processes
General Computing
Security
Groovy
Scala
Other Languages
Struts
Application Frameworks
Other Open Source Projects
BEA/Weblogic
IBM/Websphere
Oracle/OAS
Apache/Tomcat
JBoss
Other Java Products and Servers
JavaRanch
Cattle Drive (java college)
Moderators Only
Trash Can
Jobs Offered
Jobs Wanted
Jobs Discussion
Meaningless Drivel
Programming Diversions
Blatant Advertising
Java Announcements
New To Java
Advanced Java
Java Applets
Networking
Threads and Synchronization
Java 2D
AWT / Swing
SWT / JFace
CLDC and MIDP
CDC and Personal Profile
Sun Java Wireless Toolkit
Enterprise JavaBeans
JavaServer Pages (JSP) and JSTL
Java Servlet
JavaServer Faces
Web Frameworks
Database
XML
Lucene
NetBeans
Eclipse
IntelliJ IDEA
JCreator
Other IDEs
Java Tutorials
Java Tips
Jobs Discussion
Jobs Offered
Jobs Wanted
Professional Certification
Forum Lobby
Java Blogs
Introductions
Reviews / Advertising
Suggestions & Feedback

Resources

Java Database
Linux
Coding
Mobile
Hardware
Software Development
Software Development
iOS,OS X
iOS,OS X
ORACLE
IBM DEVELOPER
IBM DEVELOPER
MSDN
MSDN


Tags

Microsoft Access

The database that comes with Office Professional. Access can handle tens of thousands of rows with ease and has great connectivity support for traditional database servers.

How do I Format() for UNDERLINE??


I have a paragraph of text where I want to underline one sentence.  I created a text field, which would work fine if I knew the symbol for making the text underlined.

Right now I have this:

=" This is sentence one. " & Format("And this is sentence two.  ",">") & "This is sentence three."


What do I put in place of the ">" symbol to underline the second sentence?  The > gives all caps, which I'm just using to know my formula works.  Access help is NOT helpful here!

Sounds like you need to use Teddy's favoured solution to this problem: a RTF control - assuming of course you have such a control on your system and your client computers. If no then you will have to install it, assuming your network trolls allow you.

What's an RTF control???  And no, the trolls won't let me install anything.

As far as I know...you can not do this with the standard TextBox control that comes with Access. Either all text in the box is underlined or none of it is. 

You will need to use either the Microsoft Rich TextBox control or some other third party control which contains the selective underline feature.
 
.

Well, what I have works to give mixed formatting, but the ">" gives me all caps.  There just HAS to be a symbol that'll give underlining!!

Quote:
	
	
		
			
				Originally Posted by LisaChow
				There just HAS to be a symbol that'll give underlining!!
			
		
	
	


Hi, you must be new here... 


Access is somewhat under-developed in certain areas, you're tripping on one as we speak.

Quote:
	
	
		
			
				Originally Posted by LisaChow
				What's an RTF control???  And no, the trolls won't let me install anything.
			
		
	
	


RTF is rich text format, some access environments have it, some don't (especially the newer ones I think, or those that have Visual studio &/or studio.NET)

if you dont' have it hten you may be able to fake it using an OLE container using a text editor that supports RTF

failing that you are stuffed with a capital F.

Lisa,
  Is the one sentence always the same?  If it is you can use the conditional formating option.


	Code:
	where txtbox1.txt = "blahblahblah" then
          txtbox1.txt.underline


or something like that!

Access can help you with this if you click on 'Format' - 'Conditional Formating' then change the options.


Hope this helps,

Gene~

Quote:
	
	
		
			
				Originally Posted by Teddy
				Hi, you must be new here... 


Access is somewhat under-developed in certain areas, you're tripping on one as we speak.
			
		
	
	


Hi Teddy and all and hope you all are having a Happy New Year. For this situation can she use something like FontSize to just make the entire sentence BOLD or something instead of underlined to bring attention to it?

BUD

FontSize is a property of an entire control as I understand it, you wouldn't be able to change the size of portion of the control, it's all or nothing.  We're talking about the definition of RTF here, something that allows in-line formatting.  I've gone so far as to put browser objects on a form and populate them with formatted text just to avoid RTF shenanigans.

Thanks, all.  Geneweaver, where would I put that code???  For now I'll just YELL with ALL CAPS, but will still be on the quest for underlining.


Related Links

Table of Contents
Providing Summary by Product group
What if OpenArgs is null?
Access to vCard
Date Not Sorting...
ADO/VBA - Copy remote data into a local table
Two Column Lookup
Get the name of the clicked button
XP Spell Check Question
count no of values that are the same
How do I set the value of text boxes depending on combo box value?
Changing Mouse Pointer
Combining 2 databases
Run time error '3051':
Hi
Create Tabel Query