Capitalize

  • Thread starter Thread starter Jacob
  • Start date Start date
You're question is a little ambiguous. The first and most direct answer
would be to use the Shift key as you type the first letter. Do you always
want to force the first letter to capital but leave the others as they are?
If so, in the AfterUpdate event of the control try:

Me.txtMyTextbox = UCase(Left(Me.txtMyTextbox, 1)) & Mid(Me.txtMyTextbox, 2)

You may also want to check the options of the StrConv function.
 
Ambiguous? Well, that is always a smart thing to do is to use the shift,
however, the people inputting data do not always do that. But thank you for
your suggestion. I have a question for you that has gone unanswered. Is
there a way to display Adobe files in side of access? If so, how would one
go about creating a list of said files and make this happen?
 
I don't know of a way to display PDF files in Access. It would probably
require an ActiveX add-in. I don't know if there is one or if the one used
for Internet Explorer will work.

As far as creating a list of the files goes, you would use the DIR command
to parse a directory for the files. You could take each file found and add
it to a list box, a table, or a tree control. Parsing sub directories as
well requires a recursive routine. There are examples of doing in this in
books such as "VBA Developers Handbook" by Ken Getz and Mike Gilbert.
 
Thank you Wayne. Much appreciated.


Wayne Morgan said:
I don't know of a way to display PDF files in Access. It would probably
require an ActiveX add-in. I don't know if there is one or if the one used
for Internet Explorer will work.

As far as creating a list of the files goes, you would use the DIR command
to parse a directory for the files. You could take each file found and add
it to a list box, a table, or a tree control. Parsing sub directories as
well requires a recursive routine. There are examples of doing in this in
books such as "VBA Developers Handbook" by Ken Getz and Mike Gilbert.
 
You would be best to add hyperlinks to the pdf forms and allow users to
select the relvant hyperlink.
 
Back
Top