To use the cents symbol on your report or in a TEXT field use the extended ASCII 162, so…
Me.YourTextBox & Chr(162)
536 total views
536 total views
|
||||||
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 […] 637 total views, 2 views today I use Initials in Combo Boxes for space conservation on a Form. I don’t depend on the User to enter them, instead, I enter the below in the After_Update event of the Last Name Control on my Form… Me.txtAssociateInitials = Trim(Left(Me.txtFirstName, 1)) & Trim((" " + Left(Me.txtMiddleInitial, 1))) & Trim((" " + Left(Me.txtLastName, 1))) 1,063 total views, 1 views today 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,330 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 |
||||||