Search results for query: *

Try this I got this from this site strconv(me.text1.value,vbpropercase) Works great and easier than writing all that code. Later.

No, it isn't working. I probably should have explained better. I have a report with approximately 80 fields, it is a complex report. The main part of the report is a textbox which incorporates a string array to list names accordingly. It can vary from one name to one hundred. Underneath the name...

Only problem with that is that there is information underneath the page break, when I insert the page break I can no longer see the other information. Thanks for the post.

Hi all, Can anybody point me in the right direction, I have created a unbound report and use adodb to populate the report. The report is lengthy, but one of the fields is a memo field, when this field is filled up how do I have it print on an additional form in my access database. Any ideas or...

Hi, I have a report and I have only 21 lines that can be used for a memo field. I have other information underneath that is filled in by a recordset. Is there a way to utilize the instr function or anyother function to find out how many carraige return's and line feeds are in the textbox. Are...

Worked like a charm, used a little different approach but the philosophy was the same. Thanx FancyPrairie.

FancyPrairie,Thanks for the response will give it a try. Thanks again. Will let you know how it worked. titans

Hi, I have a form that utilizes a listview controller, the form is used by three different users, i would like to have the information dynamically refreshed each time a user enters information. Any help is greatly appreciated.

The information is presented to the user as follows: carnumber casenumber location timesent 404 004565 New Jersey 0900 hrs. i utilize the reference number on column(0) and hide it. then when the user clicks it allows him to change the time of the unit. Colors help the...

Paul, The Mouse Pointer worked well, but I could not get the subform to act like a list box. Back to square one, maybe time to move to vb. Thanks for your help.

Hi, I am trying to create a subform that will behave like a list box. I need to conditionally format the listbox with different colors. After research, I've come to the conclusion that there is no way to do this with a list box. I am attempting to now create a subform, but I was wondering if...

That was it, could not get down the quotes in the right spot. Thanks a bunch.

Hi, I am new to programming and I was wondering if anybody could help me with a LIKE statement to return values for LastName and FirstName. I tried the following, but it did not work. ME.LIST0.ROWSOURCE = "SELECT * FROM TABLE WHERE FIELD LIKE '" & ME.TEXT0 & "'" I tried...