Capitalize

[Jacob]

How do I Capitalize the first letter in a text box???

(Access 2000)

 

[RobFMS]

If its just the first letter...

Me.Text1 = UCase ( Left (Me.Text1,1) )

HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Wayne Morgan]

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.

 

[Jacob]

Thank you for your unbiased answer.

If its just the first letter...

Me.Text1 = UCase ( Left (Me.Text1,1) )

HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Jacob]

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?

 

[Wayne Morgan]

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.

 

[Jacob]

Thank you Wayne. Much appreciated.

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.

 

[Simonglencross]

You would be best to add hyperlinks to the pdf forms and allow users to
select the relvant hyperlink.

 

[Jacob]

I think you are right. I am going to go that way. Thanks again Wayne.