G Guest Dec 13, 2004 #1 I have a report and I want to elimiate all blank spaces in every field when the field is longer than the data. Please advise. thanks
I have a report and I want to elimiate all blank spaces in every field when the field is longer than the data. Please advise. thanks
R Rick B Dec 13, 2004 #2 You would have to be more specific. If you mean you have something like... [City ] [STATE] [ZIP] And you want to squeeze them together, you can do so by creating ONE unbound field and putting the source as something like... =[City] & ", " & [State] & " " & [Zip] If you are talking vertical spacing... [Address1] [Address2] [City] [State] [Zip] and you don't want to leave a blank line if Address2 is blank, then you would use the "canshrink" property of the field. Hope that helps. Rick B
You would have to be more specific. If you mean you have something like... [City ] [STATE] [ZIP] And you want to squeeze them together, you can do so by creating ONE unbound field and putting the source as something like... =[City] & ", " & [State] & " " & [Zip] If you are talking vertical spacing... [Address1] [Address2] [City] [State] [Zip] and you don't want to leave a blank line if Address2 is blank, then you would use the "canshrink" property of the field. Hope that helps. Rick B
J Jim/Chris Dec 14, 2004 #3 If you want to remove all spaces you can use a query. Here is a previous post from Allen Browne 1. Create a query into this table. 2. Drag mytextfield into the grid. In the Criteria row under this field, enter: Is Not Null 3. Change it to an Update query: Update on Query menu. Access adds an Update row to the grid. 4. In the Update row under mytextfield, enter: Replace([mytextfield], " ", "") Run the query. All spaces are now replaced with no character, so there is noneed to save the query. Or If you want to remove the spaces at the end or begining you can use the Trim and LTrim function Jim
If you want to remove all spaces you can use a query. Here is a previous post from Allen Browne 1. Create a query into this table. 2. Drag mytextfield into the grid. In the Criteria row under this field, enter: Is Not Null 3. Change it to an Update query: Update on Query menu. Access adds an Update row to the grid. 4. In the Update row under mytextfield, enter: Replace([mytextfield], " ", "") Run the query. All spaces are now replaced with no character, so there is noneed to save the query. Or If you want to remove the spaces at the end or begining you can use the Trim and LTrim function Jim
