|
||||||
Access MVP (2010-2015) |
Use the Replace() function to turn your comma delimited values into a bullet list. So… Specification ID, Alloy, Temper, Gauge, Lot Number …turns into… · Specification ID · Alloy · Temper · Gauge · Lot Number strFields: Chr(183) & " " & Replace([sdFields],", ",Chr(13) & Chr(10) & Chr(183) & " ") Note, sdFields is the […] 634 total views Combining fields is easy enough BUT when there’s a chance one of the fields might be blank (empty), well, that presents an issue. Especially, when you don’t want the comma, period or dash to show if the adjoining field is blank (empty), ie: Jane . Doe (no Middle Inital so only the period shows) or […] 1,326 total views, 1 views today There will be times when inherit a database and the Field Names are all in capital letters. You want to convert them to CamelCase but when you try they revert back to all capital letters. Here are two different ways to handle that…1. a. Change the Field Name by adding a letter to the end […] 549 total views |
Have an Access... ential you want to share? Drop me a line!
Note, all tips are moderated before posting. |
||||
|
Copyright © 2024 Access… entials - All Rights Reserved Powered by WordPress & Atahualpa |
||||||
