Formating

[Tony Ramirez]

Need help.

I have two fields on a report...they dont line up when Text is used instead
of numbers.

Field1 100.00
Field2 TBD
=IIf([Ship Via]="TBD","TBD ",[ShipAT])

Is there a solution to get them to allign correctly...or I was thinking I
could Left allign if it was text. In this scenario how would it tell "TBD" to
be left alligned?

Thanks!!!

 

[KARL DEWEY]

You did not say what your alignment consist of. Are you want all fields to
be aligned on the left, right, center, or some other like right align text on
decimal?

 

[Tony Ramirez]

Karl...

I want TBD to be alligned left and ShipAT (a numeric field) to be alligned
right. Wanting to put that in the IIF statement.

You did not say what your alignment consist of. Are you want all fields to
be aligned on the left, right, center, or some other like right align text on
decimal?
--
Build a little, test a little.

Need help.

I have two fields on a report...they dont line up when Text is used instead
of numbers.

Field1 100.00
Field2 TBD
=IIf([Ship Via]="TBD","TBD ",[ShipAT])

Is there a solution to get them to allign correctly...or I was thinking I
could Left allign if it was text. In this scenario how would it tell "TBD" to
be left alligned?

Thanks!!!

 

[KARL DEWEY]

Try this --
=IIf([Ship Via]="TBD","TBD ",Right(" " & [ShipAT], 8))

--
Build a little, test a little.

Karl...

I want TBD to be alligned left and ShipAT (a numeric field) to be alligned
right. Wanting to put that in the IIF statement.

You did not say what your alignment consist of. Are you want all fields to
be aligned on the left, right, center, or some other like right align text on
decimal?
--
Build a little, test a little.

Need help.

I have two fields on a report...they dont line up when Text is used instead
of numbers.

Field1 100.00
Field2 TBD
=IIf([Ship Via]="TBD","TBD ",[ShipAT])

Is there a solution to get them to allign correctly...or I was thinking I
could Left allign if it was text. In this scenario how would it tell "TBD" to
be left alligned?

Thanks!!!

 

[Tony Ramirez]

Doesnt really work...I only want "TBD" to be left alligned. Cant I just put
that in from like you did with Right(

Try this --
=IIf([Ship Via]="TBD","TBD ",Right(" " & [ShipAT], 8))

--
Build a little, test a little.

Karl...

I want TBD to be alligned left and ShipAT (a numeric field) to be alligned
right. Wanting to put that in the IIF statement.

You did not say what your alignment consist of. Are you want all fields to
be aligned on the left, right, center, or some other like right align text on
decimal?
--
Build a little, test a little.


:

Need help.

I have two fields on a report...they dont line up when Text is used instead
of numbers.

Field1 100.00
Field2 TBD
=IIf([Ship Via]="TBD","TBD ",[ShipAT])

Is there a solution to get them to allign correctly...or I was thinking I
could Left allign if it was text. In this scenario how would it tell "TBD" to
be left alligned?

Thanks!!!

 

[KARL DEWEY]

Doesnt really work...
What is wrong with it?
Try it and see if it does what you want.

--
Build a little, test a little.

Doesnt really work...I only want "TBD" to be left alligned. Cant I just put
that in from like you did with Right(

Try this --
=IIf([Ship Via]="TBD","TBD ",Right(" " & [ShipAT], 8))

--
Build a little, test a little.

Karl...

I want TBD to be alligned left and ShipAT (a numeric field) to be alligned
right. Wanting to put that in the IIF statement.

:

You did not say what your alignment consist of. Are you want all fields to
be aligned on the left, right, center, or some other like right align text on
decimal?
--
Build a little, test a little.


:

Need help.

I have two fields on a report...they dont line up when Text is used instead
of numbers.

Field1 100.00
Field2 TBD
=IIf([Ship Via]="TBD","TBD ",[ShipAT])

Is there a solution to get them to allign correctly...or I was thinking I
could Left allign if it was text. In this scenario how would it tell "TBD" to
be left alligned?

Thanks!!!