Recent content by Steven McEwan

Monty, I think you need square brackets at the beginning: SELECT [Better Hospital Food].[ID No] ... instead of SELECT Better Hospital Food.ID No ... Steve

Shep, That is exactly what I wanted. Thank you very much for your time in finding it. I agree that it is quite advanced - but then I did not expect it would be simple. The fact that the same functions apply to reports is also extremely helpful. Thanks again. Steve

Shep, Many thanks for your reply. I agree that "can shrink" and "can grow" will not work. I am interested in whether it is possible to use either conditional formatting (in Access 2000) or some code to generate the same effects as "can shrink" and "can grow" on screen. Thanks again. Steve

Hello, When using continuous forms in form view, is there a way to make the sizes of controls vary on screen according to the volume of content. The "can shrink" and "can grow" options work when the document is printed but not (as far as I can tell) on screen. Thanks for any help. Steve

I would add another field to the table (called "New Date"), with date format. You can then run the code below, substituting the name of your existing date field for "[Old Date]" in the line marked with stars, and the name of your table (in speechmarks) for "Dates" on the three occations it...

Many thanks for your reply. I see now that my error was to fail to use Chr(13) and Chr(10) in combination, rather than separately. I appreciate the help from both of you.

Thanks for replying, Scott. Unfortunately I cannot get this to work, as I am asked to specify the value of the parameter VbCrLf. To be clear, I have updated my text box as follows: = [Address_1] & VbCrLf & [Address_2] & VbCrLf & ... Perhaps I am using your suggestion wrongly, in which case I...

I would like to display a postal address in each record in a report. The address is made up of five fields, some of which are sometimes blank. I am using a text box as follows: =[Schedule].[Address_1] & " " & [Schedule].[Address_2] & " " & ... I would like to insert line feed characters in...