The Access Web - Strings Index

		Home
		What's New
		En Français
		Table Of Contents
		Credits
		Netiquette
		Bugs
		Tables
		Queries
		Forms
		Reports
		Modules
		APIs
		Strings
		Date/Time
		General
		Resources
		Search
		mvps.org
		Feedback

		Terms Of Use

Strings

Parse one field's data into multiple fields: How to "break" the values in one field (say, Name) in multiple fields (FirstName, LastName)
Extract characters from a string containing both numbers and characters: How to "break" the values in one field (say, Name) in multiple fields (FirstName, LastName)
Parsing character separated string into individual components: How to tokenize strings
Replace a character with another within one string: How to replace a character
Capitalize first character of every word automatically: Use StrConv in VBA5+ or a custom function in prior versions to proper case a word
Convert all text to Upper-Lower case: Use LCase or UCase to switch between cases
Increment Numeric portion of a string: Use concatenation and Right$ to deal with a number separately
Names with Mixed cases: How to proper case words taking into account names with mixed case (eg. McPherson)